audit grant privileges

From: songyu <>
Date: Wed, 23 Dec 2009 08:32:28 -0800 (PST)
Message-ID: <>

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

Original text of this message