Forum Stats

  • 3,814,159 Users
  • 2,258,828 Discussions
  • 7,892,596 Comments

Discussions

What is the difference between these privileges...

Darren2
Darren2 Member Posts: 56
edited Aug 28, 2009 1:06PM in General Database Discussions
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
Tagged:

Best Answer

  • 247514
    247514 Member Posts: 10,875 Bronze Trophy
    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

Answers

  • 689098
    689098 Member Posts: 17
    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
    689098
  • 247514
    247514 Member Posts: 10,875 Bronze Trophy
    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
  • Anurag Tibrewal
    Anurag Tibrewal Member Posts: 3,901 Gold Trophy
    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.
This discussion has been closed.