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: column masking in 10g

Re: column masking in 10g

From: Jason Heinrich <jheinrich_at_pcci.edu>
Date: Thu, 01 Mar 2007 09:41:55 -0600
Message-ID: <C20C5063.19D10%jheinrich@pcci.edu>


It depends on who owns the view. If the table owner owns the view, then he can just grant select privilege to the view, and select privileges to the table are not necessary.

On 3/1/07 9:26 AM, Don Seiler wrote:

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




Jason Heinrich
Oracle Database Administrator
Pensacola Christian College
(850) 478-8496 x2509
jheinrich_at_pcci.edu
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 01 2007 - 09:41:55 CST

Original text of this message

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