After Oracle 12c Release 1 version you can use all DB Vault functionality with Oracle Enterprise Manager Cloud Control . DBMS_MACADM PL/SQL package procedures and functions have included in Oracle Enterprise Manager. For each operation you can see the running script by pressing Show SQL button.
You should connect to Enterprise Manager to run Database Vault Administrator with a user who has DV_OWNER role. After logon Database Vault home page appears like this;
At this page ; you can see
- Violations that were made against to DB Vault rules
- Database Vault Alerts
- Audit Reports
In order to make operations on DB Vault objects; you have to go Administration section . In the below picture ; you can see Command Rules page in Administration section.
If you want to see all default rules ; you should check Show Oracle defined Command Rules box.If you want to create a new command rule; just click Create button
You can enter all necessary parameter to create a new Command Rule at this page. After clicking Show SQL button you can see the necessary script to create a new command rule
For example ; If you want to see all details about a Command Rule; Choose the Command rule
And then just double click on it.
Another functionality of DB Vault is you can control the authorization on some database operations . For example ; you can identify which user can make data pump operations , Goldengate operations or database patching. You can define all these users from Oracle Enterprise Manager by choosing ; Database Operation Authorization section
After choosing Database Operation Authorization section ; you can see all database operations which are controlled by DB Vault
You can add , edit or delete usernames from this page for each database operations.
As you see ; In Oracle 12c Release 1 version you can use all functionality of Oracle DB Vault and the most important thing is Oracle does not support old Oracle DB Vault Console after Oracle 12c version. Therefore if you are a Database Vault administrator you should learn Oracle Enterprise Manager DB Vault functionality.