9. Demonstrate the enabling and disabling of roles. The first time SALES
tries to query the SALES.T1 table, it will receive an “ORA-00942: table
or view does not exist” error. Once the USR_ROLE is activated, the same
query succeeds.
connect accounts/oracleselect * from sales.t1;set role usr_role;
Bạn đang xem 9. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P28 PPS