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

Home -> Community -> Usenet -> c.d.o.server -> Re: Parameterized Views

Re: Parameterized Views

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 13 Aug 2003 10:02:45 -0700
Message-ID: <3F3A6F35.218BD527@exxesolutions.com>


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)
Received on Wed Aug 13 2003 - 12:02:45 CDT

Original text of this message

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