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.

 

Privilege to Query Tables in Another Schema in Oracle

Privilege to Create Views in Oracle

Managing Oracle User Accounts, Schema and Privileges

⇑⇑ Oracle Database Tutorials

2019-06-29, 1550🔥, 0💬