Oracle Database 12c Security Cookbook

Running Oracle Database Vault reports

In this recipe, you will intentionally violate some security controls in order to have data for reports.

How to do it...

Let's connect as user system and violate some restrictions. First, we are going to select from hr schema, which is going to violate HR realm, and second, we are going to update sal in the scott.emp table, which is going to violate the command rule (we are updating it outside of working hours).

1. SQL> connect system@pdb1
   

2. SQL> select count(*) from hr.employees;
   

3. SQL> update scott.emp set sal = sal*1.20 where empno = 7839;
   

Let's see reports for these violations:

1. Go to Database Vault home page (See Figure 2).
2. Click on Enforcement Audit Reports (See Figure 34).

   Figure 34

3. Click on Realm Audit Report ...