Roles - Create Role SalesClerk; Grant SalesClerk to Becky;...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Roles create user alfredo identified by alfredos_secret; create user alfredo identified by alfredos_secret default tablespace ts_users temporary tablespace ts_temp; create user alfredo identified by passw0rd account lock ; CREATE PROFILE app_user LIMIT SESSIONS_PER_USER UNLIMITED CPU_PER_SESSION UNLIMITED CPU_PER_CALL 3000 CONNECT_TIME 45 LOGICAL_READS_PER_SESSION DEFAULT LOGICAL_READS_PER_CALL 1000 PRIVATE_SGA 15K COMPOSITE_LIMIT 5000000;
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online