Re: Parameterized Views

Brian Kramer wrote:

> Does oracle support parameterized views? Basically we'd like to be
> able to pass a userid to a view and based on the userid filter the
> data.
> We can get the userid into a table but the problem is that we don't
> know which user id goes with which request (we are using a common
> application login, rather than separate user logins). Is there such a
> thing as a temporary table for a given session? Or some other way to
> guarantee we are pulling the correct userid?
>
> In a nutshell we have the userid in a web application and we need a
> way to get it to the database so a view can be created that filters
> based on the userid.

Go to http://tahiti.oracle.com and look up the following topics:

SYS_CONTEXT
Fine Grained Access Control (FGAC)
Virtual Private Database
DBMS_RLS
Row Level Security

We've been doing it for years.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)