She wants to create a view in her own schema, but using another schema user's objects. At this point, I'm just waiting to hear back from her. Jeremy From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bort, Guillermo Sent: Wednesday, October 29, 2008 7:40 AM To: niall.litchfield@xxxxxxxxx; toon@xxxxxxxxxxx Cc: oracle-l Subject: RE: View Creation Actually, if the user wants to create the view in another schema, they might need create any view privilege. hth Guillermo Alan Bort DBA / DBA Main Team EDS, an HP company From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Niall Litchfield Sent: Tuesday, October 28, 2008 7:27 PM To: toon@xxxxxxxxxxx Cc: oracle-l Subject: Re: View Creation and in addition the CREATE VIEW privilege. On Tue, Oct 28, 2008 at 8:47 PM, Toon Koppelaars <toon@xxxxxxxxxxx<mailto:toon@xxxxxxxxxxx>> wrote: She needs the select object privilege granted directly from the other schema to her schema. I.e. not via a role. On Tue, Oct 28, 2008 at 9:30 PM, SHEEHAN, JEREMY <JEREMY.SHEEHAN@xxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxx>> wrote: 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 -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Toon Koppelaars RuleGen BV +31-615907269 toon_at_rulegen_dot_com www_dot_rulegen_dot_com Author: "Applied Mathematics for Database Professionals" -- Niall Litchfield Oracle DBA http://www.orawin.info