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...)
- What Is a User Account?
- What Is the Relation of a User Account and a Schema?
- What Is a User Role?
- What Are the System Predefined User Roles?
- What Are Internal User Account?
- How To Connect to the Server with User Account: SYS?
- How To Use Windows User to Connect to the Server?
- How To List All User Accounts?
- How To Create a New User Account?
- How To Change User Password?
- How To Delete a User Account?
- What Privilege Is Needed for a User to Connect to Oracle Server?
- How To Grant CREATE SESSION Privilege to a User?
- How To Revoke CREATE SESSION Privilege from a User?
- How To Lock and Unlock a User Account?
- What Privilege Is Needed for a User to Create Tables?
- How To Assign a Tablespace to a Users?
- What Privilege Is Needed for a User to Create Views?
- What Privilege Is Needed for a User to Create Indexes?
- What Privilege Is Needed for a User to Query Tables in Another Schema?
- What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema?
- What Privilege Is Needed for a User to Delete Rows from Tables in Another Schema?
- How To Find Out What Privileges a User Currently Has?
|