Re: fine grain access control

In article <4e062d34.0204251220.68bec09a_at_posting.google.com>, orclwzrd_at_yahoo.com says...
>
>Thanks, I have found that doc. However, it only explains how to
>implement FGAC. I am looking for information on the impact to indexes,
>optimization etc...

did you see my posting on this?

in short -- there is none. FGAC simply lets you add a predicate.

If you write the query in sqlplus with that predicate -- and it performs poorly, it'll perform poorly at runtime. If it works great, it'll work great.

this is simply a replacement for the EXPLOSION of views you would get otherwise. The tuning process is not very much different. anything you would have done for the many views you would have created - you will do here. It simply centralizes the security for you.

>
>"Holger Heidenbluth" <heidenbluth_at_nis-rheinsberg.de> wrote in message
>news:<3cc67e40$0$189$4d4ebb8e_at_read.news.de.uu.net>...
>> Look at article :67977.1 in MetaLink.
>>
>> Holger
>>

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp