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: FGAC

Re: FGAC

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 25 Nov 2002 12:30:45 -0000
Message-ID: <3de217f9$0$8507$ed9e5944@reading.news.pipex.net>


"Noodles" <noodles_at_aol.com> wrote in message news:20021125064915.27419.00000083_at_mb-ct.aol.com...
> Make your SQL is tuned perfectly because as you know, FGAC just appends
the SQL
> from the "rule".

Its always seemed to me that by doing this (adding silently to the where clause) FGAC *if added retrospectively to an application* could screw up access paths. Have you found this in practice or not?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Mon Nov 25 2002 - 06:30:45 CST

Original text of this message

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