2 What to Expect After You Install Oracle Database Vault

This chapter contains:

Initialization and Password Parameter Settings That Change
How Oracle Database Vault Restricts User Authorizations
Using New Database Roles to Enforce Separation of Duties
Privileges That Are Revoked or Prevented from Existing Users and Roles

Initialization and Password Parameter Settings That Change

When you install Oracle Database Vault, the installation process modifies several database initialization parameter settings to better secure your database configuration. If these changes adversely affect your organizational processes or database maintenance procedures, you can revert to the original settings.

Table 2-1 describes the initialization parameter settings that Oracle Database Vault modifies. Initialization parameters are stored in the init.ora initialization parameter file, located in $ORACLE_HOME/srvm/admin. For more information about this file, see Oracle Database Administrator's Guide.

Table 2-1 Modified Database Initialization Parameter Settings

Parameter	Default Value in Database	New Value Set by Database Vault	Impact of the Change
`AUDIT_SYS_OPERATIONS`	`FALSE`	`TRUE`	Enables the auditing of top-level operations directly issued by user `SYS`, and users connecting with `SYSDBA` or `SYSOPER` privilege. For more information about `AUDIT_SYS_OPERATIONS`, see Oracle Database Reference.
`OS_ROLES`	Not configured.	`FALSE`	Disables the operating system to completely manage the granting and revoking of roles to users. Any previous grants of roles to users using `GRANT` statements do not change, because they are still listed in the data dictionary. Only the role grants made at the operating system-level to users apply. Users can still grant privileges to roles and users. For more information about `OS_ROLES`, see Oracle Database SQL Language Reference.
`RECYCLEBIN`	`ON`	`OFF`	Controls whether the Flashback Drop feature is turned on or off. If `RECYCLEBIN` is set to `OFF`, then dropped tables do not go into the recycle bin. If it is set to `ON`, then dropped tables go into the recycle bin, which means that they can be recovered. See Also: "Security Considerations for the Recycle Bin" Oracle Database Reference for more information about `RECYCLEBIN`
`REMOTE_LOGIN_PASSWORDFILE`	`EXCLUSIVE`	`EXCLUSIVE`	Oracle Database Vault uses password files to authenticate users. The `EXCLUSIVE` setting enforces the use of the password file, if you installed Oracle Database Vault into a database where `REMOTE_LOGIN_PASSWORDFILE` is not set to `EXCLUSIVE`. For more information about `REMOTE_LOGIN_PASSWORDFILE`, see Oracle Database SQL Language Reference.
`SQL92_SECURITY`	`FALSE`	`TRUE`	Ensures that users have been granted the `SELECT` object privilege to execute such `UPDATE` or `DELETE` statements. For more information about `SQL92_SECURITY`, see Oracle Database SQL Language Reference.

How Oracle Database Vault Restricts User Authorizations

During installation of Oracle Database Vault, the installer prompts for several additional database account names. In addition, several database roles are created. These accounts are part of the separation of duties provided by Oracle Database Vault. One common audit problem that has affected several large organizations is the unauthorized creation of new database accounts by a database administrator within a production instance. Upon installation, Oracle Database Vault prevents anyone other than the Oracle Database Vault account manager or a user granted the Oracle Database Vault account manager role from creating users in the database.

For guidelines on managing separation of duty, see "Separation of Duty Guidelines".

Using New Database Roles to Enforce Separation of Duties

To meet regulatory, privacy and other compliance requirements, Oracle Database Vault implements the concept of separation of duty. Oracle Database Vault makes clear separation between the account management responsibility, data security responsibility, and database resource management responsibility inside the database. This means that the concept of a superprivileged user (for example, DBA) is divided among several new database roles to ensure no one user has full control over both the data and configuration of the system. Oracle Database Vault prevents the SYS user and other accounts with the DBA role and other system privileges from designated protected areas of the database called realms. It also introduces new database roles called the Oracle Database Vault Owner (DV_OWNER) and the Oracle Database Vault Account Manager (DV_ACCTMGR). These new database roles separate the data security and the account management from the traditional DBA role. You should map these roles to distinct security professionals within your organization.

Privileges That Are Revoked or Prevented from Existing Users and Roles

When you install Oracle Database Vault, it revokes a set of privileges from several Oracle Database-supplied roles, as part of the separation of duty enhancement.

Table 2-2 lists privileges that Oracle Database Vault revokes from existing users and roles. Be aware that if you disable Oracle Database Vault, these privileges remain revoked. If your applications depend on these privileges, then grant them to application owner directly.

Table 2-2 Privileges Oracle Database Vault Revokes

User or Role	Privilege That Is Revoked
`DBA` role	`BECOME USER` `SELECT ANY TRANSACTION` `CREATE ANY JOB` `CREATE EXTERNAL JOB` `EXECUTE ANY PROGRAM` `EXECUTE ANY CLASS` `MANAGE SCHEDULER` `DEQUEUE ANY QUEUE` `ENQUEUE ANY QUEUE` `MANAGE ANY QUEUE`
`IMP_FULL_DATABASE` role^Foot 1	`BECOME USER` `MANAGE ANY QUEUE`
`EXECUTE_CATALOG_ROLE` role	`EXECUTE ON DBMS_LOGMNR` `EXECUTE ON DBMS_LOGMNR_D` `EXECUTE ON DBMS_LOGMNR_LOGREP_DICT` `EXECUTE ON DBMS_LOGMNR_SESSION` `EXECUTE ON DBMS_FILE_TRANSFER`
`PUBLIC` user	`EXECUTE ON UTL_FILE`
`SCHEDULER_ADMIN` role^Foot 2	`CREATE ANY JOB` `CREATE EXTERNAL JOB` `EXECUTE ANY PROGRAM` `EXECUTE ANY CLASS` `MANAGE SCHEDULER`

^Footnote 1To authorize users to export and import data using Oracle Data Pump, see "Using Oracle Data Pump in an Oracle Database Vault Environment".

^Footnote 2To authorize users to schedule database jobs, see "Scheduling Database Jobs in an Oracle Database Vault Environment".

Table 2-3 lists privileges that Oracle Database Vault prevents. When Oracle Database Vault is enabled, users who have the Database Vault Account Manager role (DV_ACCTMGR) have the privileges listed in this table. If you disable Oracle Database Vault, users SYS and SYSTEM have these privileges.

Table 2-3 Privileges Oracle Database Vault Prevents

User or Role	Privilege That Is Prevented
`SYS` user^Foot 1	`ALTER PROFILE` `ALTER USER` `CREATE PROFILE` `CREATE USER` `DROP PROFILE` `DROP USER`
`SYSTEM` user	`ALTER PROFILE` `ALTER USER` `CREATE PROFILE` `CREATE USER` `DROP PROFILE` `DROP USER`

^Footnote 1For better security and to maintain separation-of-duty standards, do not enable SYS or SYSTEM users the ability to create or manage user accounts.

Note:

Both the SYS and SYSTEM users retain the SELECT privilege for the DBA_USERS_WITH_DEFPWD data dictionary view, which lists user accounts that use default passwords. If you want other users to have access to this view, grant them the SELECT privilege on it.