Bug #52977 I cannot assign "trigger" privileged to an account?
Submitted: 20 Apr 2010 11:08 Modified: 16 May 2011 18:37
Reporter: Arto Hakola Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.19 OS:Windows (Windows 7)
Assigned to: CPU Architecture:Any
Tags: privilege, trigger

[20 Apr 2010 11:08] Arto Hakola 
Description:
I couldn't find a way to add "trigger" schema privilege to an account? This option is not available?

How to repeat:
Try to create an account via WorkBench GUI that has "trigger" privilege in schema privileges.
[20 Apr 2010 11:20] Valeriy Kravchuk 
TRIGGER privilege can be granted globally, in Administrative Roles tab. But as it applies to individual tables (see http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_trigger), there must be a way to define it at schema level. Now we don't have it.
[16 May 2011 18:37] Paul DuBois 
Noted in 5.2.34 changelog.

The TRIGGER privilege could not be assigned at the schema level.