Forum Stats

  • 3,814,144 Users
  • 2,258,827 Discussions
  • 7,892,587 Comments

Discussions

Categories

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:
· Share on TwitterShare on Facebook

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
    · Share on TwitterShare on Facebook

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
    · Share on TwitterShare on Facebook
  • 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
    · Share on TwitterShare on Facebook
  • 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.
    · Share on TwitterShare on Facebook
This discussion has been closed.