Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is the difference between these privileges...

Darren2Aug 28 2009 — edited Aug 28 2009
What is the difference between these two privileges?

CREATE INDEX
CREATE ANY INDEX

I've been trying to look through Oracle's online documentation and doing Google searches, but I can't seem to get a proper search criteria to yield significant results :(

Darren
This post has been answered by 247514 on Aug 28 2009
Jump to Answer

Comments

689098
Hi,

The privilege CREATE INDEX not exist:

SQL> create user tst identified by tst;

User created.

SQL> grant create index to tst;
grant create index to tst
*
ERROR at line 1:
ORA-00990: missing or invalid privilege


SQL> grant create any index to tst;

Grant succeeded.

SQL>

Regards,

Thiago Hyppolito
1 person found this helpful
247514
Answer
As Oracle doc mentioned, there's no seperate CREATE INDEX privilege. It goes with CREATE TABLE.

To create an index in another user's schema, you must have the CREATE ANY INDEX system privilege.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_indexing.htm#sthref592
Marked as Answer by Darren2 · Sep 27 2020
Anurag Tibrewal
Hi,

Roles are
1) Index: This is given on particular table where the grantee can create an index. (No grant such as create index).
2) Create any Index: This is system privilege. This allows grantee to create index on any table on any schema.

Regards
Anurag Tibrewal.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2009
Added on Aug 28 2009
#general-database-discussions, #index
3 comments
409 views