MySQL Forums
Forum List  »  Triggers

ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
Posted by: Simone Gommaraschi
Date: November 06, 2007 04:47AM

Hi,
I created those triggers by root with this syntax

CREATE DEFINER=`userhp`@`%` TRIGGER `trg_acu_insert` BEFORE INSERT ON `tbl_anag_categ_uffici` FOR EACH ROW SET NEW.categid = 1 ;
CREATE DEFINER=`userhp`@`%` TRIGGER `trg_acu_update` BEFORE UPDATE ON `tbl_anag_categ_uffici` FOR EACH ROW SET NEW.categid = 1 ;

Mysql user `userhp`@`%` had this grants
mysql> SHOW GRANTS FOR userhp;
Grants for Userhp@% |
| GRANT USAGE ON *.* TO 'userhp'@'%' IDENTIFIED BY PASSWORD 'XxXxXxXxXx' |
| GRANT ALL PRIVILEGES ON `AppDataHP`.* TO 'userhp'@'%' |

When I try to update record of table tbl_anag_categ_uffici

mysql> update tbl_anag_categ_uffici set nome='test' where objectid = 3 ;
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation

I read documentation of grant, trigger , but it's possible that I've not understood something ; )

Can you help me ?

TIA
Simone

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
44681
November 06, 2007 04:47AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.