RE: block a field

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: 2006-01-06 22:09:32
Message-id: 20060106210932.38846.qmail@web50108.mail.yahoo.com

VPD (Fine Grained Access Control) is available in Oracle 9i.

Kirti

David Boyd wrote: Thanks, Chris. We're now in Oracle9i. When we upgrade to 10g, I \ definitely
want to try this solution.

David

>From: "Christian Antognini"
>To:
>CC:
>Subject: RE: block a field
>Date: Fri, 6 Jan 2006 21:00:30 +0100
>
>David
>
> >I should specify in more detail in my first message. Actually we want
> >blocking a field in an existing view, not a table. We don't want
>maintain
> >two sets of views and security. We prefer to modify those existing
>views.
>
>If you work with 10g you can use VPD's column masking. The feature allows
>you to let return NULL to un-authorized users. Give a look to
>DBMS_RLS.ADD_POLICY, especially to the parameter SEC_RELEVANT_COLS and
>SEC_RELEVANT_COLS_OPT.
>
>
>HTH
>Chris

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l





			
---------------------------------
Yahoo! Photos
 Ring in the New Year with Photo Calendars. Add photos, events, holidays, whatever.

Received on Fri Jan 06 2006 - 22:09:32 CST