DEMONSTRATE THE ENABLING AND DISABLING OF ROLES

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;