Creating and using Oracle Database Vault realms
A realm is a core Oracle Database Vault structure that provides logical protection against users with
any type of object-level privilege. A realm can be defined on any object in any schema. In this recipe, we will use both the PL/SQL interface and Oracle Database Vault Administrator (DVA) for defining realms.
In this chapter, we will create a realm named
HR_TABLES_REALM by using the PL/SQL interface. This realm will include all the tables from the
HR schema. Next, we will create a realm named
HR_VIEWS_REALM by using DVA Console. This realm will include all the views from the
HR schema. The user
HR will be defined as the realm owner and the users
vw_europe will be defined ...