RE: block a field
- From: "Marco Gralike" <Marco.Gralike@xxxxxxx>
- To: <rjamya@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 9 Jan 2006 10:08:57 +0100
Does this help?
http://oramossoracle.blogspot.com/2006/01/vpd-and-columnar-fgac.html
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya
Sent: zaterdag 7 januari 2006 18:44
To: oracle-l@xxxxxxxxxxxxx
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 <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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
