Syntax error What are the privileges required to use triggers?

What are the privileges required to use triggers?

We must have SUPER privileges to create or destroy triggers with the help of a CREATE or DROP statement. Other than that if the triggered statements use OLD or NEW then there are some additional privileges as follows which we require −

  • To assign the value of a column with SET NEW.column_name = value then we must have the UPDATE privilege for the column.
  • To use NEW.column_name in an expression to refer to the new value of a column, we must have the SELECT privilege for the column.
Updated on: 2020-06-22T12:09:13+05:30

236 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements