Bug #117169 Add SHOW_TRIGGER privilege
Submitted: 9 Jan 12:56 Modified: 9 Jan 14:06
Reporter: Yoni Sade Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:9.0 OS:Any
Assigned to: CPU Architecture:Any

[9 Jan 12:56] Yoni Sade 
Description:
Add SHOW_TRIGGER privilege which will:

Enable a user to access definitions and properties of all triggers, even those for which the user is not named as the routine DEFINER. This access includes:

- The contents of the Information Schema TRIGGERS table.

- The SHOW TRIGGERS statement.

This will be useful for monitoring tools or users who should only have metadata read access only.

Until the current version of MySQL, for a user to access definitions of triggers the user did not define, the user must have the TRIGGER privilege, which can be too permissive as it allows DDL statements on the triggers as well.

How to repeat:
--
[9 Jan 12:57] Yoni Sade 
(Similar to the SHOW_ROUTINE privilege added in MySQL v8.0.20)
[9 Jan 14:06] MySQL Verification Team 
Hello Yoni Sade,

Thank you for the reasonable feature request!

regards,
Umesh