Installation Guide for Oracle Billing Insight > Configuring the Oracle Database >

Enabling Oracle Auditing

You can enable Oracle auditing. You can audit as an administrator viewing the audit trail while it is active, or run standard auditing.

With standard auditing you can choose which tables to audit. It is recommended to audit the following tables, which contain sensitive data:

• EDX_BSL_AUTH_SECPROFILE
• EDX_UMF_SEC_PWD_HISTORY
• CDA_ATTRIBUTES
• USR_PASSWORD_ENTRIES
• EDX_UMF_SEC_VALIDATIONCODE
• PAYMENT_ACCOUNTS
• EDX_PMT_CHK_ACCT_ONETIME

This task is a step in Roadmap for Configuring the Oracle Billing Insight Database.

Enabling Standard Auditing

Follow these steps to enable standard database auditing.

To enable standard auditing

1. Open the init.ora initialization file for the Oracle Billing Insight EBILL database, located in the following directory:
   • UNIX. $ORACLE_HOME/dbs
   • Windows. %ORACLE_HOME%\database

     NOTE:  If you use SPFILE to store the initialization parameter, then use Database Configuration Assistant (DBCA) to change the value of the audit_trail parameter.

2. Set the Oracle static initialization parameter audit_trail to db, extended.
3. Restart the database instance.
4. Using SQL*Plus, connect to the EBILL database as the OLTP schema user.
5. For each table you want to audit, run the following command. In the command, Tablename is the database tablename.

   audit all on Tablename by access;

6. Query the system view DBA_AUDIT_TRAIL to view the audit records.

Enabling Auditing by a System Administrator

Follow these steps to enable auditing by a system administrator.

To enable auditing by a system administrator

1. Open the init.ora initialization file for the Oracle Billing Insight EBILL database, located in the following directory:
   • UNIX. $ORACLE_HOME/dbs
   • Windows. %ORACLE_HOME%\database

     NOTE:  If you use SPFILE to store the initialization parameter, then use Database Configuration Assistant (DBCA) to change the value of the audit_trail parameter.

2. Set the Oracle static initialization parameter audit_sys_operations to true.
3. Restart the database instance.
4. View the audit trail, using the Windows Event Viewer or syslog on UNIX.