RE: block a field

From: David Boyd <davidb158_at_hotmail.com>
Date: 2006-01-06 21:02:58
Message-id: BAY114-F169D2E8D91F01E2FCB506EEF210@phx.gbl

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

Received on Fri Jan 06 2006 - 21:02:58 CST