Oracle Database Vault - Part 9 ( Creating a Realm) Posted by MOHAMMED ABDUL HAMEED on 2:08 AM

Realms : It is defined as boundary or protection zone around application data.

Click on "Create" and provide the appropriate Name and Description.

Click "Ok"-> Select new "Realm" and Click on "Edit" . 

Use the drop-down list to select the owner,object type and enter the object name.

To restrict access to an entire schema,leave the " % " in the object name field.

Click ok 

Now , if we try to query then it will return ORA-01031: insufficient privileges

Oracle Database Vault - Part 8 ( Assigning the Rule sets) Posted by MOHAMMED ABDUL HAMEED on 2:06 PM

By creating the Rule Set , we can unable the functionality of the SYS User.

Steps : Login to Database Vault Page.

Select Rule Sets

Click on Create

Provide the name as : SYS_ADMIN_USER -> OK

Select from List " SYS_ADMIN_USER" and click on edit

Scroll down to " Rules Associated to the Rule Set" and Click on "Create"

Use the name “SYS_ADMIN_USER”

Enter this in the expression  field – dvf.f$session_user = ‘SYS’

Click on OK to save it, then on OK again.

Go back to the home page, and click on “Command Rules”

Select the “CREATE USER” item and click on “Edit”

Leave the command as “CREATE USER”, and in the “RULE SET” drop-down choose “SYS_ADMIN_USER”

Click on OK

The SYS user can now create users in the database.

Oracle Database Vault - Part 7 ( Restrictions on SYS User Privileges) Posted by MOHAMMED ABDUL HAMEED on 9:36 AM

By enabling database vault it restrict the SYS user from performing some database administration task.

Oracle Database Vault - Part 6 ( Logging into the Database Vault Web Page ) Posted by MOHAMMED ABDUL HAMEED on 9:14 AM

Oracle Database Vault - Part 5 ( Granting the required privileges ) Posted by MOHAMMED ABDUL HAMEED on 9:09 AM

Oracle Database Vault - Part 4 ( Implementing Database Vault with DBCA ) Posted by MOHAMMED ABDUL HAMEED on 9:06 AM

Oracle Database Vault - Part 3 ( Build Database Control ) Posted by MOHAMMED ABDUL HAMEED on 8:59 AM