Re: Mask selected column for selected users

Well, there's Oracle Label Security and/or Trusted Oracle.  I suspect
the masking functions there are slightly more sophisticated than
DBMS_RLS's null-masking.  It would be nice if VPD allowed you to mask
a subset of the column's data -- like, say, all but the last 4 digits
of a numeric field -- or to set your own mask when setting the policy,
but at least in 10gR2, that's got to be done with a view or at the
application level.

On Wed, Feb 17, 2010 at 11:23 AM, Jeffrey Beckstrom
<JBECKSTROM@xxxxxxxxx> wrote:
> I am looking into a virtual private database for selected columns.  From
> what I read, it appears that the column selected will be assigned a null
> value.  Other than creating a view , is there any other way to mask a
> selected column for selected people.
>
>
> Jeffrey Beckstrom
> Database Administrator
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113



-- 
Adam Musch
ahmusch@xxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: