RE: View Creation

[QUOTE]

I've got a user who is trying to create a view on another user's schema,
but is unable to.

[/QUOTE]

 

I'm sorry, but as I understand it, she wants to create a view "on
another user's schema"

 

Guillermo Alan Bort

DBA / DBA Main Team

 

EDS, an HP company

 

From: SHEEHAN, JEREMY [mailto:JEREMY.SHEEHAN@xxxxxxx] 
Sent: Thursday, October 30, 2008 10:31 AM
To: Bort, Guillermo; niall.litchfield@xxxxxxxxx; toon@xxxxxxxxxxx
Cc: oracle-l
Subject: RE: View Creation

 

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>
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> 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

Other related posts: