Re: Oracle Views and Permissions

From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: 12 Jul 2005 09:16:51 -0700
Message-ID: <1121185011.856826.87020@g44g2000cwa.googlegroups.com>

Hi,

Yes I see what you are saying. By creating the views in the same schema there is implict access to the data tables. Then granting access to the views only for Schema B ensures that the underlying data tables cannot be read directly by B.

The scenario relates to a production schema (Schema A) and Schema B was to consist of a resticted number of Views. I was hoping to be able to seperate the views to Schema B but this does not seem to be possible judging by your suggestion and my testing.

Thank you very much for your help.
John Received on Tue Jul 12 2005 - 11:16:51 CDT