Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Privilege Is Needed for a User to Create Indexes
What Privilege Is Needed for a User to Create Indexes? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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.
2007-05-01, 4634👍, 0💬
Popular Posts:
How does multi-threading take place on a computer with a single CPU? The operating system's task sch...
How does one iterate through items and records in a specified block? One can use NEXT_FIELD to itera...
How can you check to see whether a symbol is defined? You can use the #ifdef and #ifndef preprocesso...
How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Ora...
What is a delegate ? Delegate is a class that can hold a reference to a method or a function. Delega...