Re: block a field

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 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.

--
http://www.freelists.org/webpage/oracle-l