Re: audit grant privileges

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Wed, 23 Dec 2009 17:26:41 -0800 (PST)
Message-ID: <36302017-b2d4-4e4d-bfe0-34778452abb6_at_j4g2000yqe.googlegroups.com>



On Dec 23, 11:32 am, songyu <songy..._at_gmail.com> wrote:

snip

> 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.

Have you tried looking at the Oracle documentation? Received on Wed Dec 23 2009 - 19:26:41 CST

Original text of this message