Re: Please help! ORA-01031: insufficient privileges

From: Syltrem <syltrem_at_videotron.spammenot.ca>
Date: Tue, 11 Dec 2001 12:00:55 -0500
Message-ID: <wZqR7.3522$Q06.24683@tor-nn1.netcom.ca>

For my ALTER INDEX to work, I found that I have to GRANT CREATE ANY TABLE.

Now what sense does that make?

For every such command, the documentation should state the required privileges. More so if they are not intuitive. Does such a documentation exist? I could not find it.

Thanks!

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"Lubomir Petrov" <lpetrov_at_yahoo.com> a écrit dans le message news:
75805ad9.0112102012.4c44baf8_at_posting.google.com...


> Hi,

>

> Think for a while:

>    1) If you USE ALTER ANY INDEX privilege and USE roles you can

> rebuild the index online.

>    2) If you USE ALTER ANY INDEX privilege and DO NOT USE roles you

> CAN'T rebuild the index online.

>

> Therefore, you need one of the privileges that is granted to this

> roles. Where you can find them? In the dictionary, of course. Check

> ROLE_SYS_PRIVS and ROLE_TAB_PRIVS to see which privileges are granted

> to which roles. Now it is easy to find the answer...

>

>

> Regards

> Lyubomir Petrov

Received on Tue Dec 11 2001 - 11:00:55 CST