GRANT SOME PRIVILEGES TO THE ROLES, AND GRANT USR_ROLE TO MGR_ROLE

3. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P28 PPS
OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P28 PPS

3. Grant some privileges to the roles, and grant USR_ROLE to MGR_ROLE:

grant create session to usr_role;grant select on sales.t1 to usr_role;grant usr_role to mgr_role with admin option;grant all on sales.t1 to mgr_role;