Chapter 7, Problem 4TD

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

1. a. User Ashton must be able to retrieve data from the ITEM table.
2. b. Users Kelly and Morgan must be able to add new orders and order lines.
3. c. User James must be able to change the price for all items.
4. d. User Danielson must be able to delete customers.
5. e. All users must be able to retrieve each customer’s number, name, street, city, state, and postal code.
6. f. f User Pere7 must be able to create an index on the ORDFRS table.
7. g. User Washington must be able to change the structure of the ITEM table.
8. h. User Grinstead must have all privileges on the ORDERS table.