How to Enable Auditing in Oracle Database

 Introduction

Auditing tracks user actions in Oracle Database. This is essential for security, compliance, and troubleshooting.

Steps:

1. Connect as SYSDBA

sqlplus / as sysdba

2. Enable Auditing

ALTER SYSTEM SET audit_trail=DB SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP;

3. Audit a Specific Action

AUDIT CREATE TABLE BY SCOTT BY ACCESS;

AUDIT SELECT TABLE, INSERT TABLE BY SCOTT BY SESSION;

4. View Audit Records

SELECT username, action_name, timestamp 

FROM dba_audit_trail 

ORDER BY timestamp DESC;

Conclusion

Auditing provides visibility into user activity, helping DBAs enforce security and detect suspicious behavior.