audit grant privileges
Date: Wed, 23 Dec 2009 08:32:28 -0800 (PST)
I am currently auditing "GRANT ANY OBJECT PRIVILEGE" and "GRANT ANY PRIVILEGE". That works well if I grant privileges of other schema objects to others.
I would also like to audit in cases where a schema grants its objects to other schemas. For eg. if I log in as scott and issue the following statment:
grant select on emp to hr;
I want the above statement to also be audited.
What is the audit command to accomplish that?
thanks. Received on Wed Dec 23 2009 - 10:32:28 CST