Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FGA vs. Triggers

Re: FGA vs. Triggers

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 14 Oct 2007 19:13:02 -0700
Message-ID: <1192414359.408910@bubbleator.drizzle.com>


Jake wrote:
> 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?

No. What I said was that what constitutes "an audit" is not one size fits all. Without knowing the business rules any answer is either a crude approximation or just plain wrong.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Oct 14 2007 - 21:13:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US