Re: Trigger on grant and revoke command

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Wed, 27 Jun 2007 05:03:48 -0700
Message-ID: <1182945828.361239.50700@c77g2000hse.googlegroups.com>

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