Re: Another permission question...

2003-09-18 Thread Victoria Reznichenko
"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 ha

Another permission question...

2003-09-17 Thread Tore Bostrup
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