Re: column masking in 10g
- From: "Don Seiler" <don@xxxxxxxxx>
- To: jheinrich@xxxxxxxx
- Date: Thu, 1 Mar 2007 09:26:57 -0600
Don't you need select privileges on the underlying tables of a view in
order to select from the view?
Don.
On 3/1/07, Jason Heinrich <jheinrich@xxxxxxxx> wrote:
One solution that doesn't involve VPD is to just create a view that doesn't
include that column. Then grant access to the view to your restricted users
and revoke their access to the base table. Of course, unless you have
synonyms in place for this table, this would involve changing the code that
accesses the table.
--
Don Seiler
http://seilerwerks.blogspot.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
