Create Realm-Secured objects to protect schema objects
Purpose:Protect HR schema object from system privileged users
Step 1:
Login as sys or system
Step 2:
Query HR.EMPLOYEES table
(Query: select count(*) from hr.employees;
Output: count of rows)
Step 3:
Creating Realm-Secured Objects for hr.employees table
Query HR.EMPLOYEES table
(Query: select count(*) from hr.employees;
Output: Error "ORA-01031: insufficient privileges")
Step 4:
Disable Realm and query HR.EMPLOYEES table
(Query: select count(*) from hr.employees;
Output: count of rows)
Step 5:
Screenshot explains the above scenario
No comments:
Post a Comment