Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
audit grant privileges
3 views
Skip to first unread message
songyu
Dec 23, 2009, 11:32:28 AM12/23/09
to
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 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.
hpuxrac
Dec 23, 2009, 8:26:41 PM12/23/09
to
On Dec 23, 11:32 am, songyu <songy...@gmail.com> wrote:
snip
Have you tried looking at the Oracle documentation?
0 new messages