MySQL Forums
Forum List  »  Newbie

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




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.