MySQL asking a user for SUPER privilege to perform a delete.

Posted by Fran on Server Fault See other posts from Server Fault or by Fran
Published on 2010-05-11T16:01:46Z Indexed on 2010/05/11 16:04 UTC
Read the original article Hit count: 274

Filed under:
|
|
|

Hello,

When trying to do a delete operation on a table, mysql reports the following error:

Error code 1227: Access denied; you need the SUPER privilege for this operation.

However, my user has this privilege granted for all tables in the schema:

GRANT ALL PRIVILEGES ON myschema.* TO 'my_admin'@'%'

How come it asks me for SUPER privilege for a delete?

Thanks in advance.

© Server Fault or respective owner

Related posts about mysql

Related posts about privileges