RE: block a field

Does this help?

http://oramossoracle.blogspot.com/2006/01/vpd-and-columnar-fgac.html  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: zaterdag 7 januari 2006 18:44
To: oracle-l_at_freelists.org
Subject: 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



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