Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

About CREATE INDEX OBJECT PRIVILEGE

user8794108Mar 14 2015 — edited Mar 14 2015

I wanna know if really this object privilege (CREATE INDEX) exits and what is it for ?

I have understood that the ability to create a index is coming with the CREATE TABLE Object privilege, because when you define a PRIMARY KEY or UNIQUE constraint, it automatically create a associated index.

I know too, that exist a CREATE ANY INDEX System Privilege, that is for create index in any user account.

So, really this object privilege (CREATE INDEX) exits and what is it for ?

THKS!!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2015
Added on Mar 14 2015
2 comments
5,364 views