Database Security Products (MOSC)

MOSC Banner

Audit grant object privileges for all uses include sysdba

edited May 22, 2014 2:51PM in Database Security Products (MOSC) 3 commentsAnswered

I set audit_trail=DB and audit_sys_operations=ture, this allow me to audit sysdba to grant object privileges, I can find the inforamtion in audit_file_dest

Then I login as sysdba, SQL>audit grant any object privilege by access; Then I login as normal user to grant select on xxx.test to userid, later I view dba_audit_trail, I can't find anything there.

Unless I run <audit grant on xxx.xxx by access> on the specific table, then I can find this in dba_audit_trail.

Is there anyway to audit all the users' grants?

Thanks,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center