Chapter 7, Problem 4SCG

Write, but do not execute, the commands to grant the following privileges:

1. a. User Oliver must be able to retrieve data from the CONDO_UNIT table.
2. b. Users Crandall and Perez must be able to add new owners and condo units to the database.
3. c. Users Johnson and Klein must be able to change the condo fee of any unit.
4. d. All users must be able to retrieve the unit number, condo fee, and owner number for every condo unit.
5. e. User Klein must be able to add and delete service categories.
6. f. User Adams must be able to create an index on the SERVICE_REQUEST table.
7. g. Users Adams and Klein must be able to change the structure of the CONDO_UNIT table.
8. h. User Klein must have all privileges on the LOCATION, OWNER, and CONDO_UNIT tables.