Go to the FreeLists Home Page Home Signup Help Login
 



[oracle-l] || [Date Prev] [03-2007 Date Index] [Date Next] || [Thread Prev] [03-2007 Thread Index] [Thread Next]

Re: column masking in 10g

  • From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • To: davidb158@xxxxxxxxxxx
  • Date: Thu, 1 Mar 2007 09:09:11 -0500
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@xxxxxxxxxxx> 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





[ Home | Signup | Help | Login | Archives | Lists ]

All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
Everything else ©2007 Avenir Technologies, LLC.