"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
<___/ www.mysql.com
