Hi, all,

I am having trouble of revoking global privileges. Your help will be greatly appreciated.

   I created a user called "dummy" identified by password "dummy" by :
grant usage on *.* to 'dummy'@'%' identified by 'dummy';

Then I did:
mysql> show grants for dummy;
+-----------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+-----------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dummy'@'%' IDENTIFIED BY PASSWORD '710e7e2213ba44ca' |
+-----------------------------------------------------------------------------+


     It looked fine. However strange thing happened after I did
flush privileges;

show grants for dummy; would give me:
+----------------------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+----------------------------------------------------------------------------------------------------------------------------+
| GRANT SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'dummy'@'%' IDENTIFIED BY PASSWORD '710e7e2213ba44ca' |
+----------------------------------------------------------------------------------------------------------------------------+


I don't understand how this could happen. Are the privileges for SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES ON *.* default global privileges? Is there a way to turn this off so the user dummy has no global privileges at all?

        I am using MySQL 4.0.20 on Solaris.

        Thanks in advance for your help.

Regards,
Zhe


Reply via email to