Re: FGA vs. Triggers

From: Jake <jgarfield_at_earthlink.net>
Date: Sun, 14 Oct 2007 14:49:59 -0700
Message-ID: <1192398599.313576.325620@i38g2000prf.googlegroups.com>

On Oct 14, 12:56 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Jake wrote:
> > With fine grained auditing available, is there any need to use
> > triggers to do auditing anymore? Do people still use triggers to do
> > auditing? Thanks.
>
> Depends on your business rules and what constitutes an audit trail.
> The same question might be asked with respect to Log Miner.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Do you mean the business rules have to be more complex than FGA can handle to warrant using triggers instead of FGA? Or is there some other consideration that would make one use triggers instead?

And, since you mentioned, say I did ask the same question about Log Miner, would the answer be the same? Received on Sun Oct 14 2007 - 16:49:59 CDT