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.
⇒ Privilege to Query Tables in Another Schema in Oracle
⇐ Privilege to Create Views in Oracle
2019-06-29, 1550🔥, 0💬
Popular Posts:
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...