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?
It won't hurt, but it isn't required. Just don't grant less permissions than what is asked for in the documentation.
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... ;-)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.