"Tore Bostrup" <tore@stripped> wrote:
> MySQL 3.23.36 (yeah, I know it's getting old...):
> What permission do I need to run the following query:
> REVOKE ALL
> ON mydb.* FROM 'sdaf'@'%';
> I get an error 1044:
> "Access denied for user: 'Admin@<IP address>' to database 'mydb'"
> My user has GRANT permission on mydb (database) and GRANT permission on all tables
> except two (with only SELECT permission). I tried removing all table based permissions,
> but that didn't help. I assigned GRANT permissions to all tables in the database, but
> that didn't help either.
> Assigning SELECT, UPDATE permissions on the mysql database didn't help either?
You should have GRANT privilege and the same privileges as you try to revoke, i.e. if you
write "REVOKE ALL ..", you should have all privileges on the database mydb.
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net