Re: block a field

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 7 Jan 2006 12:43:32 -0500

Create a view with the same name as table except for the field, for
those users for whom you wish to block the field.

This is also another good use of views, and simple to implement. So
these users will perform all select and dml through the view, they
will never see the field.

Raj

On 1/6/06, Kirtikumar Deshpande <kedeshpande@xxxxxxxxx> wrote:
> I stand corrected.
>  Column masking is what I did not do in 9i. I had only implemented VPD (for
> FGAC). So, I can't conclusively say that one could modify policies to
> achieve column masking. I have not tested it myself.
>  Sorry.
--
//www.freelists.org/webpage/oracle-l


Other related posts: