Re: DBMS_RLS: Fine-Grained Access Control - Table name substitution

On Wed, 9 Jul 2003 19:15:57 +0200, "Bepy" <ramengo_at_hotmail.com> wrote:

>Hi, I know Fine-Grained Access Control permits adding a predicate to manage
>access to objects.
>The predicate is in the form of WHERE clause so you only can add filter to
>controlled object.
>
>Is there a way to substitute the object name ?
>
>I need to deviate table selection into another table based on user access...
>
>TIA.
>

No, You don't need to that.
Rethink your design and don't try to be 'smart'. You should set up your system so you can use the pseudo function user

Why do you think when it isn't in the docs, it is still possible?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 09 2003 - 12:45:10 CDT