Hello, I have a weird problem with privileges and deleting from tables.
I have a MySQL user that has only "mydb2" database specific privileges (no SUPER privileges). All tables were created prior to granting any privileges.
Privileges have been granted by this query: "GRANT ALL PRIVILEGES ON `mydb2` . * TO 'user_mydb'@'%' WITH GRANT OPTION ;"The problem is that I get "ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation" every time I try to delete from some tables of this database.
For instance, "delete from table1;" works, but "delete from table2;" doesn't!
Could anyone help me or point where to look for an answer? Any help would be appreciated, thank you! -- Best regards, Sergei
smime.p7s
Description: S/MIME Cryptographic Signature