"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@<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 / /|_/ / // /\ \/ /_/ / /__ [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]