OraFAQ Forum: Security » Audit overview was is being audited

Home » RDBMS Server » Security » Audit overview was is being audited (Oracle DB Standard, 11.2.0.4, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Audit overview was is being audited [message #633334]

Mon, 16 February 2015 03:05

Flyby
Messages: 188
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.

Report message to a moderator

Re: Audit overview was is being audited [message #633336 is a reply to message #633334]

Mon, 16 February 2015 03:36

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Audit overview was is being audited [message #633339 is a reply to message #633336]

Mon, 16 February 2015 06:01

Flyby
Messages: 188
Registered: March 2011
Location: Belgium

Senior Member

Thank you

Report message to a moderator

Previous Topic:	name of computer
Next Topic:	ACL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 18:19:14 CDT 2025