"create index" not needed for Oracle database?

Almut Hack February 12, 2019

I have to migrate from MySQL to Oracle. The documentation tells me which privileges to grant. I'm wondering why it doesn't contain

grant create index to <user>;

 Would it hurt, if I granted this permission?

1 answer

1 accepted

0 votes
Answer accepted
Dave Theodore [Coyote Creek Consulting]
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 12, 2019

It won't hurt, but it isn't required. Just don't grant less permissions than what is asked for in the documentation.  

Almut Hack February 13, 2019

Thanks a lot for the quick answer! That helps me to keep my database schemes consistent. Maybe I was irritated by the statement "if either less or more than these privileges are applied, some JIRA functions may not work properly", but good to hear that this is not valid for the "create index" privilege...  ;-)

Suggest an answer

Log in or Sign up to answer