[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
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-