I seem to be having some trouble with using GRANT and REVOKE. I am implementing a "user management" form in my application that does the following:
REVOKE ALL ON mydb.* FROM 'Username'@'%' I get an error "Access denied for user: 'MyAdmin@<ipaddress>' to database 'mydb'". The Revoke statement is being executed (via MyODBC 3.51) connected as a user with the permission defined in the following script: -- Create User account if not exists: GRANT USAGE ON mydb.* to 'MyAdmin'@'%' identified by 'MyPwd'; GRANT UPDATE ON mysql.* to 'MyAdmin'@'%' identified by 'MyPwd'; FLUSH PRIVILEGES; -- Make sure no previously created user by this name has anything beyond the required privileges: REVOKE ALL ON mydb.* FROM 'MyAdmin'@'%'; FLUSH PRIVILEGES; USE mydb; -- assign required privileges: GRANT USAGE ON mydb.* TO 'MyAdmin'@'%' identified by 'MyPwd' WITH GRANT OPTION; GRANT DELETE, INSERT, SELECT, UPDATE ON TableX TO 'MyAdmin'@'%' identified by 'MyPwd' WITH GRANT OPTION; GRANT DELETE, INSERT, SELECT, UPDATE ON TableY TO 'MyAdmin'@'%' identified by 'MyPwd' WITH GRANT OPTION; GRANT SELECT ON TableZ TO 'CL.Admin'@'%' IDENTIFIED BY 'CL.4d31n' WITH GRANT OPTION; FLUSH PRIVILEGES; Any ideas why this doesn't work as I expect it to? I couldn't find any related info in the MySQL doc'n. TIA, Tore. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
