e-Commerce Applications Using Oracle8i and Java from Scratch

Auditing JavaStop Activity

Oracle8i provides an auditing facility that can be used to audit database access. Both successful and unsuccessful attempts can be audited for the following actions:

• Login attempts

• Access to objects

• System privileges and statements without regard to the object being accessed

Note

Auditing is enabled by using the AUDIT command and disabled by using the NOAUDIT command.

In order to use auditing, the following steps must be taken:

1. Connect to server manager as the SYS account.

2. Run CATAUDIT.SQL.

3. In the init.ora file, set the parameter AUDIT_TRAIL to the appropriate value:

   DB (for database) — This enables systemwide auditing and causes audited records to be written to the database's audit trail (SYS.AUD$ table). If this option ...