Oracle - Privilege to Create Indexes in Oracle

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

2019-06-29, 877👍, 0💬

Assign a Tablespace to a User in Oracle
How To Assign a Tablespace to a Users in Oracle? When you create a new user, Oracle will assign the SYSTEM tablespace to the user by default. If you want to change this, you can assign a different table space to a user using the ALTER USER command. The following tutorial exercise changes user dev's ... 2019-06-29, 922👍, 0💬

Privilege to Create Indexes in Oracle
What Privilege Is Needed for a User to Create Indexes in Oracle? 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: >.\... 2019-06-29, 878👍, 0💬

Privilege to Query Tables in Another Schema in Oracle
What Privilege Is Needed for a User to Query Tables in Another Schema in Oracle? For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to query tables i... 2019-06-11, 814👍, 0💬

Privilege to Insert Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema in Oracle? For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to insert rows in "hr" sch... 2019-06-11, 800👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.