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 [EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------+
| 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
