Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trigger on grant and revoke command
On Jun 27, 10:58 am, Steve Robin <ocma..._at_gmail.com> wrote:
> Is there any way to create trigger on grant and revoke commands.
> So that as soon as anyone execute them.... they get recorded in my
> table not in aud$ after audit
Yes.
RTFM: Oracle Application Developer's Guide - Fundamentals, Oracle Concepts Guide and Oracle SQL Reference for your Oracle release. It's all there, method and examples.
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Wed Jun 27 2007 - 07:03:48 CDT