MySQL Bugs: #17597: CREATE TRIGGER does not check privileges the standard way

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:	None
Category:	MySQL Server: Stored Routines	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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:

Abandon the use of "to be fixed later" so going to status "verified"