How To Enable Audit Options In A Database

SQL> show parameter audit_trail

NAME TYPE VALUE

———————————— ———– ——

audit_trail string DB

SQL> AUDIT ALTER ANY OUTLINE BY ACCESS;

Audit succeeded.

SQL> AUDIT ALTER ANY ROLE BY ACCESS;

Audit succeeded.

SQL> AUDIT ALTER DATABASE BY ACCESS;

Audit succeeded.

SQL> AUDIT ALTER SEQUENCE BY ACCESS;

Audit succeeded.

SQL> AUDIT ALTER SYSTEM BY ACCESS;

Audit succeeded.

SQL> AUDIT ALTER TABLE BY ACCESS;

Audit succeeded.

SQL> AUDIT AUDIT ANY;

Audit succeeded.

SQL> AUDIT AUDIT SYSTEM BY ACCESS;

Audit succeeded.

SQL> AUDIT CLUSTER BY ACCESS;

Audit succeeded.

SQL> AUDIT CONTEXT BY ACCESS;

Audit succeeded.

SQL> AUDIT CREATE ANY OUTLINE BY ACCESS;

Audit succeeded.

SQL> AUDIT CREATE ROLE BY ACCESS;

Audit succeeded.

SQL> AUDIT CREATE SESSION BY ACCESS;

Audit succeeded.

SQL> AUDIT DATABASE LINK BY ACCESS;

Audit succeeded.

SQL> AUDIT DIMENSION BY ACCESS;

Audit succeeded.

SQL> AUDIT DIRECTORY BY ACCESS;

Audit succeeded.

SQL> AUDIT DROP ANY OUTLINE BY ACCESS;

Audit succeeded.

SQL> AUDIT DROP ANY ROLE BY ACCESS;

Audit succeeded.

SQL> AUDIT INDEX BY ACCESS;

Audit succeeded.

SQL> AUDIT PROCEDURE BY ACCESS;

Audit succeeded.

SQL> AUDIT PROFILE BY ACCESS;

Audit succeeded.

SQL> AUDIT PUBLIC DATABASE LINK BY ACCESS;

Audit succeeded.

SQL> AUDIT PUBLIC SYNONYM BY ACCESS;

Audit succeeded.

SQL> AUDIT SEQUENCE BY ACCESS;

Audit succeeded.

SQL> AUDIT SYNONYM BY ACCESS;

Audit succeeded.

SQL> AUDIT SYSDBA BY ACCESS ;

Audit succeeded.

SQL> AUDIT SYSOPER BY ACCESS ;

Audit succeeded.

SQL> AUDIT SYSTEM AUDIT BY ACCESS;

Audit succeeded.

SQL> AUDIT SYSTEM GRANT BY ACCESS;

Audit succeeded.

SQL> AUDIT TABLE BY ACCESS;

Audit succeeded.

SQL> AUDIT TABLESPACE BY ACCESS;

Audit succeeded.

SQL> AUDIT TRIGGER BY ACCESS;

Audit succeeded.

SQL> AUDIT TYPE BY ACCESS;

Audit succeeded.

SQL> AUDIT USER BY ACCESS;

Audit succeeded.

SQL> AUDIT VIEW BY ACCESS;

Audit succeeded.

SQL> AUDIT INSERT, UPDATE, DELETE ON sys.aud$ BY ACCESS;

Audit succeeded.

SQL> SELECT * FROM DBA_STMT_AUDIT_OPTS;

USER_NAME PROXY_NAME AUDIT_OPTION SUCCESS FAILURE

—————————— —————————— —————————————- ———- ———-

ALTER SYSTEM BY ACCESS BY ACCESS

SYSTEM AUDIT BY ACCESS BY ACCESS

CREATE SESSION BY ACCESS BY ACCESS

TABLE BY ACCESS BY ACCESS

CLUSTER BY ACCESS BY ACCESS

TABLESPACE BY ACCESS BY ACCESS

USER BY ACCESS BY ACCESS

ROLLBACK SEGMENT BY ACCESS BY ACCESS

TYPE BY ACCESS BY ACCESS

INDEX BY ACCESS BY ACCESS

SYNONYM BY ACCESS BY ACCESS

PUBLIC SYNONYM BY ACCESS BY ACCESS

VIEW BY ACCESS BY ACCESS

SEQUENCE BY ACCESS BY ACCESS

DATABASE LINK BY ACCESS BY ACCESS

PUBLIC DATABASE LINK BY ACCESS BY ACCESS

ROLE BY ACCESS BY ACCESS

DIMENSION BY ACCESS BY ACCESS

PROCEDURE BY ACCESS BY ACCESS

TRIGGER BY ACCESS BY ACCESS

PROFILE BY ACCESS BY ACCESS

DIRECTORY BY ACCESS BY ACCESS

MATERIALIZED VIEW BY ACCESS BY ACCESS

ALTER TABLE BY ACCESS BY ACCESS

NOT EXISTS BY ACCESS BY ACCESS

SYSDBA BY ACCESS BY ACCESS

SYSOPER BY ACCESS BY ACCESS

ALTER SEQUENCE BY ACCESS BY ACCESS

CREATE ROLE BY ACCESS BY ACCESS

DROP ANY ROLE BY ACCESS BY ACCESS

ALTER ANY ROLE BY ACCESS BY ACCESS

AUDIT ANY BY ACCESS BY ACCESS

SYSTEM GRANT BY ACCESS BY ACCESS

ALTER DATABASE BY ACCESS BY ACCESS

CONTEXT BY ACCESS BY ACCESS

CREATE ANY OUTLINE BY ACCESS BY ACCESS

ALTER ANY OUTLINE BY ACCESS BY ACCESS

DROP ANY OUTLINE BY ACCESS BY ACCESS

38 rows selected.

SQL> SELECT * FROM DBA_PRIV_AUDIT_OPTS;

USER_NAME PROXY_NAME PRIVILEGE SUCCESS FAILURE

—————————— —————————— —————————————- ———- ———-

DROP ANY OUTLINE BY ACCESS BY ACCESS

ALTER ANY OUTLINE BY ACCESS BY ACCESS

CREATE ANY OUTLINE BY ACCESS BY ACCESS

ALTER DATABASE BY ACCESS BY ACCESS

AUDIT ANY BY ACCESS BY ACCESS

ALTER ANY ROLE BY ACCESS BY ACCESS

DROP ANY ROLE BY ACCESS BY ACCESS

CREATE ROLE BY ACCESS BY ACCESS

SYSOPER BY ACCESS BY ACCESS

SYSDBA BY ACCESS BY ACCESS

CREATE SESSION BY ACCESS BY ACCESS

AUDIT SYSTEM BY ACCESS BY ACCESS

ALTER SYSTEM BY ACCESS BY ACCESS

13 rows selected.