Then you grant limited authorizations to this realm. To accomplish this, you will add the HR schema to the secured objects of the protection zone, which in Oracle Database Vault is called a realm, inside the database. In the HR schema, the EMPLOYEES table has information such as salaries that should be hidden from most employees in the company, including those with administrative access. In this tutorial, you will create a simple security configuration for the HR sample database schema.
You can log in if you have the DV_ADMIN or DV_OWNER roles.įigure 3-1 shows the Oracle Database Vault Administrator home page, which appears after you log in.ģ.2 Quick Start Tutorial: Securing a Schema from DBA Access When the login page appears, log in by using the Oracle Database Vault Owner account that you created during installation.īy default, you cannot log in to Oracle Database Vault Administrator by using the SYS, SYSTEM, or other administrative accounts. Log files are in the following directory: $ORACLE_HOME/sysman/log If necessary, select Start from the menu to start the database console.
#Oracle database vault windows
On Windows systems: In the Administrative Services, select the Services utility, and then right-click the OracleDBConsole sid service. If you must start the dbconsole process, then run the following command. On UNIX systems: Navigate to the $ORACLE_HOME/bin directory and run the following command. If you cannot start Oracle Database Vault Administrator, check that the Oracle database console process is running. Port: The Oracle Enterprise Manager Console HTTP port numberįor example: If you are unsure of the port number, open the ORACLE_HOME / host_sid /sysman/config/emd.properties file and search for REPOSITORY_URL. Host_name: The server where you installed Oracle Database Vault
To start Oracle Database Vault Administrator:įrom a browser, enter the following URL: host_name: port/dva In Chapter 4, "Enterprise Manager Security," go to "Configuring Security for the Database Control."
#Oracle database vault pdf
On the Oracle Enterprise Manager 10 g Release 1 (10.1) Documentation page, select either PDF or HTML for Oracle Enterprise Manager Advanced Configuration, whose part number is B12013-03. On the Oracle Enterprise Manager 10 g Release Documentation page, under Other Releases, select the Oracle Enterprise Manager Release 1 (10.1) Documentation link. To access this manual, visit Oracle Technology Network (OTN) atįrom the Documentation menu, select Enterprise Manager. For more information, see Oracle Enterprise Manager Advanced Configuration in Oracle Enterprise Manager 10 g Release 10.1. If you are using Oracle Enterprise Manager Database Control, you can configure it for an SSL (HTTPS) secure connection.