SQL revoke

[hknmtt]

Mam mariadb/mysql databazu kde spustam prikaz

Kód: [Vybrat]

GRANT CREATE, DROP, INSERT, UPDATE, DELETE, SELECT on db.* TO foo@localhost WITH GRANT OPTION
nasledne spustam

Kód: [Vybrat]

REVOKE DROP, UPDATE, DELETE ON db.tbl1 FROM foo@localhost
avsak dostavam chybu

ERROR 1147 (42000) at line 1: There is no such grant defined for user 'foo' on host 'localhost' on table 'tbl1'

Skusal som medzi grant a revoke spravit FLUSH PRIVILEGES, ale nepomohlo to.

Otazka - je mozne toto vyriesit bez toho, aby som definoval granty pre kazdu tabulku v databaze samostatne?

[Reklama]

[hknmtt]

Asi som na to prisiel. Namiesto revoke pouzijem grant na tu konkretnu tabulku, co by malo mat prioritu pred db.*