Thursday, 14 November 2013

Create Realm-Secured objects to protect schema objects

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