A person who has an account on server wants to use MySQL triggers. I found out he cannot unless I manually grant him SUPER privilege. I would like to know more before proceeding.
How can this affect overall server performance? Which doors do I open by giving this person this privilege, could he change mysql server configuration or access other accounts databases? What happens if he has a logic error in a trigger he creates, could it crash our mysql server?
I have not used triggers before, and I read that you need to be careful using them. I just would like to have more accurate information to make a decision.
Thanks for any help.