List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:September 18 2003 4:04pm
Subject:Re: Another permission question...
View as plain text  
"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




Thread
Another permission question...Tore Bostrup18 Sep
  • Re: Another permission question...Victoria Reznichenko18 Sep