Answer Happy

Consider the following Schema EMPLOYEE Name Ssn Bdate Address Sex Salary Dno DEPARTMENT Dnumber Dname Mgr_ssn Assume that the admin creates 4 accounts: User1, User2, User3, and User4 1. The admin wants only user1 to create Schema, what command must be accomplished by the admin? 2. Now assume that Userl wants to grant user2 the insert and delete privileges on those relations (Tables) but User2 will not be able to grant those privileges. what command must be accomplished by User1 3. Now assume that Userl wants to grant user3 the retrieve privileges from relations (Tables) and User3 will be able to grant this privilege to other. what command must be accomplished by User1 4. Create a command in order to allow user3 to Grant the select privilege to User4. 5. Assume now that User1 wants to revoke the select privilege on table employee from User3. what command must be accomplished by User1 6. Assume now that user1 grants the Select privilege again to user3 but with the following fields only: Name, address and BDate. How can User1 accomplish this command without using the grant statement DIRECTLY on those fields? 7. Assume now that User1 grants the update privilege on Employee.Salary's field to User4. what command must be accomplished by User1