"Tore Bostrup" <[EMAIL PROTECTED]> 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@' 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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
