Re: Mask selected column for selected users
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: JBECKSTROM@xxxxxxxxx
- Date: Wed, 17 Feb 2010 11:34:17 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
