Unformatted text preview: Create Role SalesClerk; Grant SalesClerk to Becky; Grant SalesClerk to Bob; Grant SalesClerk to bil; GRANT DELETE ON ORDERS TO SalesClerk Really good while handing a lot of users. GRANT SELECT ON PRODUCT TO PUBLIC; enables anyone with access to system(public) to view product table WITH GRANT OPTION; delegates users to grant roles to other people REVOKE [GRANT OPTION FOR] privilege-list ON OBJECT FROM user-list;...
View Full Document
- Winter '10
- Statistics, Limit, Default, Grant SalesClerk