Oracle Database Vault - Part 10 ( Granting access by using Realm ) Posted by MOHAMMED ABDUL HAMEED on 4:22 AM

To Allow any specific user to access the table.

To allow the user mahameeditpro to access the table emp.salinfo , the below mention steps need to followed :

Click on the Realm

Select the Realm and select Realm Authorizations -> Click Create

Select the specific user from the Drop down list -> Click "OK"

Now , Lets Login to the database by mahameeditpro and check the access.

Now you can access the particular table by using the specific user , Hope its helpful. 

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