RE: View Creation

From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 28 Oct 2008 16:30:41 -0400

I've got a question in View creation and I think it has to do with permissions 
on the base tables.

I've got a user who is trying to create a view on another user's schema, but is 
unable to.  She can select on the tables with no problem, but when she goes to 
create the view she gets an 'insufficient privileges' error.   Does she need 
select with admin option on the tables in question?

Thanks guru's!

Jeremy

Follow-Ups:
- Re: View Creation
  - From: Toon Koppelaars

References:
- shared storage solution
  - From: bao jiejie
- Re: shared storage solution
  - From: Roman Podshivalov

RE: View Creation

Other related posts: