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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.