Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

grant create index on specific table

I'm using oracle and I want to create an index to a specific table belongs to another user so how I grant the privilege to do so without using the requete

grant create any index 
like image 621
Djaballah Mohammed DJEDID Avatar asked Oct 29 '25 15:10

Djaballah Mohammed DJEDID


1 Answers

grant index on [tablename] to [user]

What privileges the table owner him/herself must have in order to be allowed to grant create index on a table to another user will depend on your version of Oracle; check the documentation.