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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With