Link to home
Start Free TrialLog in
Avatar of Billy Ma
Billy MaFlag for Hong Kong

asked on

Oracle Audit

How can I know which audit option is currently enabled in Oracle database?

e.g.
If I type
AUDIT DATABASE LINK BY SESSION WHENEVER SUCCESSFUL;

the Oracle database will start auditing this right?

But how can I know all the audit rules and setting that are enabled in Oracle?

Is it just query the DBA_AUDIT_TRAIL table?

I don't think so....
Which table can I find out Oracle is curerntly auditing the above statement?
ASKER CERTIFIED SOLUTION
Avatar of Naveen Kumar
Naveen Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Billy Ma

ASKER

thanks