Collections:
Privilege to Create Indexes in Oracle
What Privilege Is Needed for a User to Create Indexes in Oracle?
✍: FYIcenter.com
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.
2019-06-29, 877👍, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...