Re: Privileges

In <stauffer-1212951156020001_at_bannerclient.swarthmore.edu>, stauffer_at_swarthmore.edu (stauffer) writes:
>Running into a problem on a new, vendor-installed database and my mind has
>gone blank...
>
>Here is the error I get when a user tries to create a view:
>
>ERROR at line 4:
>ORA-01933: cannot create a stored object using privileges from a role

Seems to me that its wanting to create store procedures..... The user had its privileges given by its role. Make sure that is the default role(s). Use the set role command in SQLDBA.

>
>The user has the dba role and was granted 'create view' explicitly.
>
>So, what am I missing?
>
>Thanks,
>
>Glenn Stauffer
>
>To get random signatures put text files into a folder called ³Random Signatures² into your Preferences folder.

I will try it on my setup and see what I get. I have created a PBUSER Oracle role that i grant to the users.

Carlos Coronel
Computer Information Systems
Middle Tennessee State University
1500 Greenland Dr.
Murfreesboro TN 37132
e-mail: ccoronel_at_mtsu.edu Received on Thu Dec 14 1995 - 00:00:00 CET