Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: column masking in 10g
David
Have you already tried "DBMS_RLS.ADD_POLICY" and "EXEMPT ACCESS POLICY" ?
http://www.stanford.edu/dept/itss/docs/oracle/10g/network.101/b10773/apdvcntx.htm#1014673
-Rajeev
On 3/1/07, David Boyd <davidb158_at_hotmail.com> wrote:
>
> Hi All,
>
> We¡¯d like to block a column for some users, but open to other users. We
> don¡¯t care about row level security. If the user has the privilege to
> see
> the column data, she/he gets to see the data in the column for the entire
> table. Otherwise the column is null. I was wondering if any one uses VPD
> column masking in 10g to block columns. If you do, could you please share
> your code with me?
>
> Dave
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 01 2007 - 08:09:11 CST
![]() |
![]() |