Hi,

Stephen Liu wrote:
> Hi Baron,
>
>
> Tks for your advice.
>
>
>> To undo this GRANT, run
>>
>> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
>> 'vmailuser'@'localhost';
>
> mysql> REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
> 'vmailuser'@'localhost';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql>
>
> I suppose it has been done ???

Yes, but you can check with SHOW GRANTS FOR 'vmailuser'@'localhost' to be sure. If you
are running an older version of MySQL you may also need to run FLUSH PRIVELEGES. Check
the manual for the versions where this is necessary.

Baron