Is it possible to give a user privilege to view Triggers, i.e. execute
the SHOW TRIGGERS command, without also giving them permission to DROP
No. In a few words
show triggers and
drop trigger requires the same
statement returns results only for databases and tables for which you
have the TRIGGER privilege.
- DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger.
Enables trigger operations. You must have this privilege for a table to create, drop, execute, or display triggers for that table.
When a trigger is activated (by a user who has privileges to execute INSERT, UPDATE, or DELETE statements for the table associated with the trigger), trigger execution requires that the user who defined the trigger still have the TRIGGER privilege for the table.