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: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Thu, 1 Mar 2007 09:11:43 -0600
Message-ID: <de807caa0703010711wcadcb25tc2cd8ccac4e2068c@mail.gmail.com>


David,

Call me old-fashioned (might as well, everybody else does), but have you considered a couple of simple views. One view offers the columns for one set of users. Another view sets certain columns to null. Synonyms as needed.
Sometimes the simple solution is the best.

Dennis Williams

On 3/1/07, David Boyd <davidb158_at_hotmail.com> wrote:
>
> Hi All,
>
> Wed like to block a column for some users, but open to other users. We
> dont 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
>
> _________________________________________________________________
> Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a
> month.
> Intro*Terms
>
> https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 01 2007 - 09:11:43 CST

Original text of this message

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