Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: block a field
VPD (Fine Grained Access Control) is available in Oracle 9i.
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
-- 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
![]() |
![]() |