Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Privilege to Create Indexes

By: FYIcenter.com

(Continued from previous topic...)

What Privilege Is Needed for a User to Create Indexes?

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.

(Continued on next topic...)

1. What Is a User Account?
2. What Is the Relation of a User Account and a Schema?
3. What Is a User Role?
4. What Are the System Predefined User Roles?
5. What Are Internal User Account?
6. How To Connect to the Server with User Account: SYS?
7. How To Use Windows User to Connect to the Server?
8. How To List All User Accounts?
9. How To Create a New User Account?
10. How To Change User Password?
11. How To Delete a User Account?
12. What Privilege Is Needed for a User to Connect to Oracle Server?
13. How To Grant CREATE SESSION Privilege to a User?
14. How To Revoke CREATE SESSION Privilege from a User?
15. How To Lock and Unlock a User Account?
16. What Privilege Is Needed for a User to Create Tables?
17. How To Assign a Tablespace to a Users?
18. What Privilege Is Needed for a User to Create Views?
19. What Privilege Is Needed for a User to Create Indexes?
20. What Privilege Is Needed for a User to Query Tables in Another Schema?
21. What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema?
22. What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema?
23. How To Find Out What Privileges a User Currently Has?