Create Trigger requires privilege SUPER


#1

Hi,

i’ve some trouble, since 1 day, i want to create a trigger, but i couldn’t identify the source of the problem.

This is in fact only the privilege, as is indeed privilege “SUPER”. But in the wiki, it’s noted i may not have this privileges.
Is there no solution to allow me to create my triggers?

Regards
Arta.


#2

No, there’s no way to create triggers on our MySQL servers at the present time. This will become possible as we move to MySQL 5.1, but I don’t have any timeline on that.


#3

[code]Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2089711
Server version: 5.1.39-log MySQL Server

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> CREATE TRIGGER activity_summary_bu
-> BEFORE UPDATE ON activity_summary FOR EACH ROW
-> BEGIN
-> SET NEW.activity_summary = 5;
-> END
-> $$;
ERROR 1142 (42000): TRIGGER command denied to user ‘essnadmin’@‘waratahs.dreamhost.com’ for table ‘activity_summary’
[/code]

Any update on this? I need to create an audit trail for some of my tables, and would really prefer to do it via triggers, rather than manual inserts prior to updates.


#4

In case it wasn’t clear, I’ll highlight it:

Server version: [size=xx-large]5.1.39[/size]-log MySQL Server

All I want is to be able to create on update triggers to insert into history tables