Index privilege
604542Jul 9 2008 — edited Oct 27 2008Hi,
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;