Bug #30973 CREATE TRIGGER is not functioning

Submitted:	12 Sep 2007 13:05	Modified:	12 Oct 2007 13:41
Reporter:	Benjamin Howarth	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Information schema	Severity:	S2 (Serious)
Version:	6.0.0-alpha-community-debug	OS:	Windows (2003 Enterprise Edition)
Assigned to:		CPU Architecture:	Any
Tags:	create, Event, schema, trigger

Description:
When I try to grant permissions for TRIGGER and EVENT on any schema for a user, the UI appears to accept this but when the schema is refreshed the granted permissions for TRIGGER and EVENT disappear, and when using CREATE TRIGGER get a "permission denied" error for all users.
This happens with all users, including sa.

How to repeat:
See above

Suggested fix:
No ideas, never come across problem before.

Thank you for the bug report. Could you please try with the last released
version 6,0.2-alpha and if you still get the same behavior please provide
the exact step you did to try to repeat on our side. Thanks in advance.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.