Re: Privileges

stauffer (stauffer_at_swarthmore.edu) wrote:
: 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
:
: The user has the dba role and was granted 'create view' explicitly.
:
: So, what am I missing?

No user can create a view based on a table/view in another person's schema unless they have been granted SELECT (at least) on the base table/view directly to the user who wants to create the view.

Even though the user may have SELECT privs on the base view or table as a result of a role, you still need the direct grants to create objects based on other users' objets.

Joe

:
: Thanks,
:
: Glenn Stauffer
:
: To get random signatures put text files into a folder called ³Random Signatures² into your Preferences folder.

-- 
                                   
=------------------------------------------------------------------=
Joe Nardone <joe_at_access.digex.net> 
"Now that I have my coffee, I'm ready to watch radar."

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2

mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7
pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL
YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu
bmV0Pg==
=1ocE
-----END PGP PUBLIC KEY BLOCK-----