Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!i38g2000prf.googlegroups.com!not-for-mail From: Jake Newsgroups: comp.databases.oracle.server Subject: Re: FGA vs. Triggers Date: Sun, 14 Oct 2007 14:49:59 -0700 Organization: http://groups.google.com Lines: 25 Message-ID: <1192398599.313576.325620@i38g2000prf.googlegroups.com> References: <1192378596.466524.308300@k35g2000prh.googlegroups.com> <1192380986.77038@bubbleator.drizzle.com> NNTP-Posting-Host: 65.87.162.35 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1192398600 19386 127.0.0.1 (14 Oct 2007 21:50:00 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sun, 14 Oct 2007 21:50:00 +0000 (UTC) In-Reply-To: <1192380986.77038@bubbleator.drizzle.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: i38g2000prf.googlegroups.com; posting-host=65.87.162.35; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Xref: usenetserver.com comp.databases.oracle.server:436306 X-Received-Date: Sun, 14 Oct 2007 17:50:00 EDT (text.usenetserver.com) On Oct 14, 12:56 pm, DA Morgan 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...@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?