Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: block a field

Re: block a field

From: rjamya <rjamya_at_gmail.com>
Date: 2006-01-07 18:43:32
Message-id: 9177895d0601070943u35c94d3cyf13738a90822ad34@mail.gmail.com


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
Received on Sat Jan 07 2006 - 18:43:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US