Bug #17597 CREATE TRIGGER does not check privileges the standard way
Submitted: 20 Feb 2006 20:20 Modified: 22 Jan 2014 14:26
Reporter: Sergei Golubchik Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[20 Feb 2006 20:20] Sergei Golubchik
According to the SQL standard, CREATE TRIGGER should only succeed if the definer has TRIGGER privilege and SELECT privilege in case OLD or NEW pseudo-rows are used. The second check is not performed now.

(it's the first part of bug#17033)

How to repeat:
[22 Jan 2014 14:26] Ståle Deraas
Abandon the use of "to be fixed later" so going to status "verified"