Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: audit 'revoke' statement
desertflowerln_at_yahoo.com (Alan) wrote in message news:<b1217045.0405201239.a5e16d6_at_posting.google.com>...
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<40ac4a34$0$26908$626a14ce_at_news.free.fr>...
> > > I know those two views. But by just doing 'Audit System Grant;' and > with audit_trail=DB, I don't see any audit record in those two views. > That's why I ask to see whether they are stored somewhere else. > > Thanks for the reply.
What user are you doing the GRANTs and REVOKEs as? You should see it in those views, unless you are doing the GRANT while connected as SYS - in that case you probably won't find it in the audit trail because actions done by SYS are not audited the same as a normal user.
-- Joe http://www.cafeshops.com/joekaz http://www.joekaz.netReceived on Fri May 21 2004 - 13:53:50 CDT