MySQL Forums
Forum List  »  Newbie

Re: ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT
Posted by: sverre rakkenes
Date: December 20, 2011 08:49PM

Thanks for feedback,

I moved the database to to a different mysql server (dump and create), and I discovered the error. this is a TRIGGER problem.

It looks like there is a trigger when we INSERT, UPDATE or DELETE this TABLE. I can find the triggers by running this line.

SHOW TRIGGERS\G

*************************** 1. row ***************************
Trigger: his_trigger_insert_product
Event: INSERT
Table: PRODUCT
Statement: BEGIN
INSERT INTO HIS_PRODUCT SET
HIS_ACTION = 'INSERT'
, PRODUCTNU = NEW.PRODUCTNU, TEXTNU = NEW.TEXTNU, TXT = NEW.TXT, TEMPLATE =
(...)
NEW.SEFURL, LEVEL3_HEADING = NEW.LEVEL3_HEADING, IMAGE_PCAT = NEW.IMAGE_PCAT
;
END
Timing: AFTER
Created: NULL
sql_mode:
Definer: xxxx@xxx.xxx.xxx.xx (username and host removed)
(...)

Options: ReplyQuote


Subject
Written By
Posted
Re: ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT
December 20, 2011 08:49PM


Sorry, you can't reply to this topic. It has been closed.

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.