RE: block a field

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

David Boyd <davidb158@xxxxxxxxxxx> 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.

Other related posts: