Privilege to Create Indexes in Oracle

Q

What Privilege Is Needed for a User to Create Indexes in Oracle?

✍: FYIcenter.com

A

For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise gives you a good example on creating view privilege:

>.\bin\sqlplus /nolog
SQL> connect SYSTEM/fyicenter

SQL> GRANT CREATE TABLE TO dev;
Grant succeeded.

SQL> disconnect
SQL> CONNECT DEV/developer

SQL> CREATE INDEX fyi_index ON fyi(id);
Index created.

SQL> DROP INDEX fyi_index;
Index dropped.

SQL> CREATE INDEX fyi_index ON fyi(id);
Index created.

This exercise assumes that you followed previous exercises in the FAQ collection.

 

Managing Oracle User Accounts, Schema and Privileges

⇒⇒Oracle Database Tutorials

2016-10-17, 137👍, 0💬