mySQL user account grants

[STEPHEN E SUTHERLAND]

We are installing Jira locally with a mySQL database. From the install doc the following grants are needed: SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX My question is after we get everything installed, can we pull back the permissions? I don't like leaving an application account with create/drop/alter permissions.

[Nic Brough -Adaptavist- · Accepted solution]

No, it still needs all those rights for Active objects and upgrades.

(Although you could arguably lose the "drop and alter" during normal running when you don't upgrade the core or any plugins)