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!

Index privilege

604542Jul 9 2008 — edited Oct 27 2008
Hi,
I've created a new user and I'd like to grant that user permission to create indexes but can't get it to work. I keep getting 'Invalid privilege error'

My new user is called user1. My new role is user1roll. I've tried granting to both my new user and role but does not work.

GRANT CREATE INDEX TO user1roll;
GRANT CREATE INDEX TO user1;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2008
Added on Jul 9 2008
15 comments
3,785 views