Re: privileges and deleting from tables

[Sergei]

Hello,

Thanks for the answer!
I checked the thing you suggested:
1) output of SHOW GRANT is correct
2) the problematic table is not a view



Baron Schwartz wrote:

3) no triggers - only foreign key constraint. "ADD CONSTRAINT `mydb2_table2_ibfk_1` FOREIGN KEY (`table2_user_id`) REFERENCES `table1` (`usr_id`) ON DELETE CASCADE". By the way I forgot to mention that engine is of course InnoDB.

Hi Sergei,

Sergei wrote:

Hello,

I have a weird problem with privileges and deleting from tables.



Privileges have been granted by this query:






Could anyone help me or point where to look for an answer?

Any help would be appreciated, thank you!

I have a MySQL user that has only "mydb2" database specific privileges (no SUPER privileges). All tables were created prior to granting any privileges. "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!

That is odd.  Some things I can think of:

1) check the output of SHOW GRANTS just to be sure.
2) Is one table a view?
3) are there any triggers on the tables?

Cheers.

--
Best regards,

Sergei

smime.p7s
Description: S/MIME Cryptographic Signature