Re: column masking in 10g

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.

-- 
Don Seiler
http://seilerwerks.blogspot.com
--
http://www.freelists.org/webpage/oracle-l