nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

"create index" not needed for Oracle database?

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?

Accepted answers

Dave Theodore [Coyote Creek Consulting]

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

All comments

Dave Theodore [Coyote Creek Consulting]

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... ;-)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration