Re: revoke all on *.* ??

2008-06-10 Thread Simon J Mudd
[EMAIL PROTECTED] (Pawel Eljasz) writes: > there is a user with following grants: > GRANT USAGE ON *.* TO 'ff'@'localhost' IDENTIFIED BY PASSWORD > 'x' > is it possible to: > revoke all on *.* from $above_user OR revoke usage on *.* from $above_user > ? DROP USER [EMAIL PROTECTED]; Simo

RE: revoke all on *.* ??

2008-06-10 Thread Martin Gainty
Pawel- the syntax is GRANT USAGE ON DB.* to '[EMAIL PROTECTED]' IDENTIFIED BY PASSWORD 'NeverShowYourPasswordInEmail' http://dev.mysql.com/doc/refman/5.0/en/grant.html HTH Martin Gainty __ Disclaimer and confidentiality note Everything in this e-