Home » RDBMS Server » Security » Audit overview was is being audited (Oracle DB Standard, 11.2.0.4, Windows)
Audit overview was is being audited [message #633334] Mon, 16 February 2015 03:05 Go to next message
Flyby
Messages: 187
Registered: March 2011
Location: Belgium
Senior Member
Hello,

Is there an easy way to get an overview what is being audited? (CREATE SESSION, SET ROLE ...)

The closest thing I got was DBA_STMT_AUDIT_OPTS.
DBA_COMMON_AUDIT_TRAIL shows what was audited.

My google search is lacking.

Thanks in advance.
Re: Audit overview was is being audited [message #633336 is a reply to message #633334] Mon, 16 February 2015 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 66474
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There are 4 main views: dba_obj_audit_opts, dba_priv_audit_opts, dba_stmt_audit_opts and all_def_audit_opts.

Re: Audit overview was is being audited [message #633339 is a reply to message #633336] Mon, 16 February 2015 06:01 Go to previous message
Flyby
Messages: 187
Registered: March 2011
Location: Belgium
Senior Member
Thank you
Previous Topic: name of computer
Next Topic: ACL
Goto Forum:
  


Current Time: Fri Jul 19 07:42:29 CDT 2019