Bug #9412 Triggers: should have trigger privilege
Submitted: 26 Mar 2005 15:50 Modified: 29 May 2007 16:34
Reporter: Peter Gulutzan
Status: Not a Bug
Category:Server Severity:S3 (Non-critical)
Version:5.1 OS:Linux (SUSE 9.2)
Assigned to: Alexander Nozdrin Target Version:

[26 Mar 2005 15:50] Peter Gulutzan 
Description:
To create a trigger, there is a standard privilege on the table: TRIGGER.
This privilege should be granted/revoked with GRANT TRIGGER / REVOKE TRIGGER.
The SUPER privilege should be irrelevant.

How to repeat:
mysql> grant trigger on t to wanda;
ERROR 1064 (42000): You have an error in your SQL syntax; ...
[1 Jun 2005 21:27] Brian Aker 
Will fix in 5.1
[1 Feb 2006 1:03] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/1974
[1 Feb 2006 11:30] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/1991
[1 Feb 2006 11:39] Alexander Nozdrin 
Pushed into 5.1 tree, currently tagged 5.1.6.
[1 Feb 2006 19:29] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2018
[2 Feb 2006 0:34] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).
[2 Feb 2006 11:36] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2056
[5 Mar 2006 11:20] Konstantin Osipov 
Bug#16457 has been marked as a duplicate of this bug.
[5 Mar 2006 11:21] Konstantin Osipov 
Sorry, Bug#16597 has been marked as a duplicate of this bug.
[29 May 2007 12:18] Kris Groves 
Any plans to port this fix to 5.0 ?
[29 May 2007 15:47] Alexander Nozdrin 
Sorry, but we weren't planning to backport it.
[29 May 2007 16:22] Kris Groves 
Thanks for the fast response :)

If it's not being backported, when can we expect 5.1 to be the generally available
production release ? (I'd look that up, but I can't find any release plan at mysql.com,
maybe i'm blind -.-)
[29 May 2007 16:34] Alexander Nozdrin 
Sorry, but I can't answer this question. Also the bug system is not the appropriate forum
for asking help on using MySQL products.

Support on using our products is available both free in our forums at
http://forums.mysql.com/ and for a reasonable fee direct from our skilled support
engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.