Step 2: Enable Auditing for SELECT Statements on the OE.CUSTOMERS Table

Next, enable auditing for SELECT statements on the OE.CUSTOMERS table.

To enable auditing of SELECT statements for the OE.CUSTOMERS table:  

1. Ensure that the sample user sec_admin exists.

   Log on as SYSTEM, and then from the Database Control home page, click Server to display the Server subpage. Select Users under Security, and check the list of accounts for sec_admin. "Step 1: Create a Security Administrator Account" explains how to create the sec_admin security administrator account. If you still have Oracle Database Vault enabled, then you must recreate the account using the Database Vault Account Manager account.

2. In SQL*Plus, log in as user OE and then grant sec_admin the SELECT privilege on the OE.CUSTOMERS table.

   sqlplus oe
   Enter password: password
   Connected.
   
   SQL> GRANT SELECT ON CUSTOMERS TO sec_admin;
   

3. Log in to Database Control as user SYS with the SYSDBA privilege.

4. Click Server to display the Server subpage.

5. In the Security section, click Audit Settings.

   The Audit Settings page appears.

6. Select the Audited Objects subpage.

7. Click Add.

   The Add Audited Object page appears.

8. Enter the following information:

   • Object Type: Select Table.

   • Table: Enter OE.CUSTOMERS.

   • Available Statements: Select SELECT, and then click Move to move it to the Selected Statements list.

9. Click OK.

10. Log out of Database Control.