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.

2. Grant sec_admin the SELECT privilege on the OE.CUSTOMERS table.

3. Log in to Database Control as user sec_admin.

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. Shut down the database instance and then restart it.

    1. In the upper, right corner of the Database Control page, select Logout.

    2. Click Login.

    3. In the Login page, enter the following login information:

       User Name: SYS

       Password: The password of the system administrator

       Connect As: SYSOPER

       Use the SYSOPER system privilege to shut down and restart the database.

    4. Under General, click Shutdown.

    5. In the Startup/Shutdown Credentials page, enter your credentials.

       See Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control for more information.

    6. After the shutdown completes, click Startup.

    7. Exit Database Control.