About Oracle audit (audit)

Oracle audit can be used to query the operations performed by a user on the database. After 10 Gb, it can be used to query specific SQL statements.

The entire process of opening an account with the audit function:

1. show parameter audit. You can query the audit_trail value, which can be {none | OS | db, extended | xml, extended}

2. alter system set audit_trail = DB scope = spfile;

After performing the preceding operations, restart the database.

3. audit table, which records the operation actions of user-created tables, truncate tables, and drop tables.

Note: After 10 GB (inclusive), dba_audit_trail. SQL _text records the specific SQL statement, which can be viewed, and audit_trail must be db_extended or db, extended; otherwise, audit cannot be viewed.

4. Audit is divided:

Statement, object, privilege, network

5. Cancel, noaudit