Skip navigation links

MySQL Forums :: Newbie :: ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT


Advanced Search

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

we have Server version: 5.0.51a-24+lenny5 (Debian)

I run this command:

insert into PUBLISH (TXT,INGRESS,LEVELS,PUBLISH_UP,LINK,HIS_USER_ID,FREETEXT,ACTIVE,PUBLISH_ID,TEMPLATE,PRIORITY) values ('test53','','0','1260','','100764','','on','1283','artikkelkategori','50');

and get this error reported:

ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation

but, otherwise the data is inserted... and things seems to work. is this a bug? or something I am doing wrong?

mysql> desc PUBLISH;
+------------------+-----------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+-----------------+------+-----+-------------------+-------+
| PUBLISH_ID | varchar(50) | NO | PRI | | |
| TXT | varchar(100) | NO | | | |
| LOGO | varchar(255) | NO | | | |
| FREETEXT | text | NO | | NULL | |
| TEMPLATE | varchar(30) | NO | | | |
| PRIORITY | int(11) | NO | | 0 | |
| MISC1 | varchar(255) | NO | | | |
| MISC2 | varchar(255) | NO | | | |
| SHOP_ID | varchar(30) | YES | | NULL | |
| LEVELS | int(11) | NO | | 0 | |
| PUBLISH_UP | varchar(50) | NO | | 0 | |
| ACTIVE | char(3) | YES | | on | |
| TS | timestamp | NO | | CURRENT_TIMESTAMP | |
| ACCESS_INTERNETT | set('on','off') | YES | | on | |
| ACCESS_EXTRANETT | set('on','off') | YES | | off | |
| ACCESS_INTRANETT | set('on','off') | YES | | off | |
| MD5_UPDATE | varchar(32) | YES | | NULL | |
| MD5_MASTER | varchar(32) | YES | | NULL | |
| INGRESS | text | YES | | NULL | |
| LINK | varchar(255) | YES | | NULL | |
| HELP_ID | int(11) | YES | | NULL | |
| ICON | varchar(255) | YES | | NULL | |
| SEFURL | varchar(255) | YES | | NULL | |
| HIS_USER_ID | int(11) | YES | | NULL | |
+------------------+-----------------+------+-----+-------------------+-------+

before:
mysql> select * from PUBLISH where PUBLISH_ID = "1283";
Empty set (0.00 sec)

after:
| PUBLISH_ID | TXT | LOGO | FREETEXT | TEMPLATE | PRIORITY | MISC1 | MISC2 | SHOP_ID | LEVELS | PUBLISH_UP | ACTIVE | TS | ACCESS_INTERNETT | ACCESS_EXTRANETT | ACCESS_INTRANETT | MD5_UPDATE | MD5_MASTER | INGRESS | LINK | HELP_ID | ICON | SEFURL | HIS_USER_ID |
+------------+--------+------+----------+------------------+----------+-------+-------+---------+--------+------------+--------+---------------------+------------------+------------------+------------------+------------+------------+---------+------+---------+------+--------+-------------+
| 1283 | test53 | | | artikkelkategori | 50 | | | NULL | 0 | 1260 | on | 2011-12-19 05:04:10 | on | off | off | NULL | NULL | | | NULL | NULL | NULL | 100764 |
+------------+--------+------+----------+------------------+----------+-------+-------+---------+--------+------------+--------+---------------------+------------------+------------------+------------------+------------+------------+---------+------+---------+------+--------+-------------+

Options: ReplyQuote


Subject Written By Posted
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT sverre rakkenes 12/18/2011 10:17PM
Re: ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT Rick James 12/20/2011 01:50PM
Re: ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT sverre rakkenes 12/20/2011 08:49PM
Re: ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation on simple INSERT sverre rakkenes 12/21/2011 02:04AM


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.