Bug #9412 Triggers: should have trigger privilege

• Submitted: 26 Mar 2005 14:50
• Modified: 29 May 2007 14:34
• Reporter: Peter Gulutzan
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Linux (SUSE 9.2)
• Assigned to: Alexander Nozdrin
• CPU Architecture: Any

[26 Mar 2005 14: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 19:27] Brian Aker

Will fix in 5.1

[1 Feb 2006 0: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 10: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 10:39] Alexander Nozdrin

Pushed into 5.1 tree, currently tagged 5.1.6.

[1 Feb 2006 18: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

[1 Feb 2006 23: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 10: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 10:20] Konstantin Osipov

Bug#16457 has been marked as a duplicate of this bug.

[5 Mar 2006 10:21] Konstantin Osipov

Sorry, Bug#16597 has been marked as a duplicate of this bug.

[29 May 2007 10:18] Kris Groves

Any plans to port this fix to 5.0 ?

[29 May 2007 13:47] Alexander Nozdrin

Sorry, but we weren't planning to backport it.

[29 May 2007 14: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 14: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.