Hi folks,


OpenBSD 4.0 x86_64
Mysql
Postfix_2.4.3


After running following command;

mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test.* TO
'vmailuser'@'localhost' IDENTIFIED BY 'password123';
Query OK, 0 rows affected (0.00 sec)


I found I made a mistake to run it. I need to revoke the GRANT given to
vmailuser to test database.


I found on;
13.5.1.5. REVOKE Syntax
http://dev.mysql.com/doc/refman/5.0/en/revoke.html

The syntax;
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user]

but can't resolve whether retaining the 1st 'user'
and
replace [, user] with [, vmailuser]???

Please shed me some light. TIA


B.R.
Stephen Liu


Send instant messages to your online friends http://uk.messenger.yahoo.com