Hi Baron,


> > I suppose it has been done ???
>
> Yes, but you can check with SHOW GRANTS FOR 'vmailuser'@'localhost'
> to be sure.


mysql> SHOW GRANTS FOR 'vmailuser'@'localhost';
+------------------------------------------------------------------------------------------------------------------+
| Grants for vmailuser@localhost
|
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'vmailuser'@'localhost' IDENTIFIED BY PASSWORD
'*A0F874BC7F54EE086FCE60A37CE7887D8B31086B' |
+------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
* end *

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


I'm running Mysql version;

$ mysql --version
mysql Ver 14.12 Distrib 5.0.24a, for unknown-openbsd4.0 (x86_64) using
readline 4.3


To safe guard, it would be better to run 'FLUSH PRIVELEGES'.

Can I re-run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';

then

FLUSH PRIVELEGES;
???

Tks.


B.R.
Stephen

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