Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: column masking in 10g

Re: column masking in 10g

From: Rajeev Prabhakar <rprabha01_at_gmail.com>
Date: Thu, 1 Mar 2007 09:09:11 -0500
Message-ID: <2ba656800703010609h4995dfbco1cabffb33184fc0a@mail.gmail.com>


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-l
Received on Thu Mar 01 2007 - 08:09:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US