Re: CHALLENGING:: Dynamic OR Session specific Views. Possible?

"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message news:aa6dnXyoecoyYRHfRVn-iQ_at_comcast.com...
>
> <vistav20_at_yahoo.com> wrote in message
> news:1116534960.671779.97210_at_f14g2000cwb.googlegroups.com...
>> Hi,
>>
>> Is it possible to create a view or a version of data accessible through
>> same object name (table or view), which returns different values for
>> different sessions?
>>
>> Here is what I am trying to do:
>>
>> I need to create a view with a different underlying query each time it
>> is accessed. But I still need it to behave like a static object so I
>> could use it to link with an external tool (so, it's name and structure
>> etc will not change, just the underlying query and it's where clause
>> willl change). To make matters more complex, the query would be
>> different for different people logged in, hence the SESSION SPECIFIC
>> contstraint.
>>
>> Any ideas?
>>
>> thanks much,
>> Mark
>>
>
> yes,
>
> you want VPD (Virtual Private Database) functionality, AKA 'FGA' (Fine
> Grained Access) -- see
> http://www.oracle.com/technology/pub/articles/10gdba/week14_10gdba.html
>
> ++ mcs
>

PS: you just need to post to one group -- keep any future response in comp.databases.oracle.server (didn't notice the cross-posting on my first reply) Received on Thu May 19 2005 - 15:54:49 CDT