Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: CHALLENGING:: Dynamic OR Session specific Views. Possible?

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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 19 May 2005 16:53:01 -0400
Message-ID: <aa6dnXyoecoyYRHfRVn-iQ@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 Received on Thu May 19 2005 - 15:53:01 CDT

Original text of this message

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