Installation Guide for Oracle Self-Service E-Billing > Configuring the Oracle Database >

Enabling Oracle Auditing

You can enable Oracle auditing. You can audit as an administrator viewing the audit trail live, or run standard auditing to a database.

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

To enable standard auditing

1. Open the init.ora initialization file found in the $ORACLE_HOME/dbs directory (or the %ORACLE_HOME%\ database directory for Windows) for the Oracle Self-Service E-Billing OLTP database.
2. Set the Oracle static initialization parameter audit_trail to db, extended.
3. Restart the database instance.
4. Using SQL*Plus, connect to the OLTP database as the OLTP schema user.
5. For each table you want to audit, run the following command, where Tablename is the database tablename:

   audit all on Tablename by access;

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

To enable auditing by a system administrator

1. Open the init.ora initialization file found in the $ORACLE_HOME/dbs directory (or the %ORACLE_HOME%\ database directory for Windows) for the Oracle Self-Service E-Billing OLTP database.
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.