Database Security - minimum privileges?

avatar JimS Pro Jan 18. 2010. 2:07 pm #1
Hi, have searched the forums but couldn't find anything:
What are the minimum required privileges the DB_USER has to be granted in mySql
a) on install
b) for daily operation
Thank you
avatar Ilija Studen Staff Jan 18. 2010. 2:11 pm #2
activeCollab uses all Data commands, most Structure commands (upgrade script), but it does not require any administration commands. Basically, let activeCollab manage the data and structure of the tables, and you can turn off other commands.
avatar JimS Pro Jan 18. 2010. 3:16 pm #3
Thanks for the quick reply!
avatar matt_janiczek Pro Feb 1. 2010. 2:37 am #4
Hi,

just to be sure:
Which commands are administration commands?

Can somebody post a small list, please?
avatar Ilija Studen Staff Feb 1. 2010. 5:50 am #5
Hello Matt,

Please check the screenshot Jim attached in the first post. Administration commands are the ones in the third group.
avatar matt_janiczek Pro Feb 2. 2010. 1:10 am #6
uuh,
thank you.
I was kind of blind ;)