audit grant privileges

From: songyu <songyu21_at_gmail.com>
Date: Wed, 23 Dec 2009 08:32:28 -0800 (PST)
Message-ID: <0638b748-461d-4d59-9d05-337269121663_at_g12g2000vbl.googlegroups.com>

Hi,
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