Hi,
the documentation reads:
REVOKE /|priv_type|/ [(/|column_list|/)] [, /|priv_type|/ [(/|column_list|/)]]
...
ON {/|tbl_name|/ | * | *.* | /|db_name|/.*}
FROM /|user|/ [, /|user|/] ...
REVOKE ALL PRIVILEGES, GRANT OPTION FROM /|user|/ [, /|user|/] ...
but it doesn't work, as you can see below:
grant all privileges on *.* to user3;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for user3;
+--------------------------------------------+
| Grants for [EMAIL PROTECTED] |
+--------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'user3'@'%' |
+--------------------------------------------+
1 row in set (0.00 sec)mysql> show variables like 'version';
+---------------+----------------+
| Variable_name | Value |
+---------------+----------------+
| version | 4.0.21-Max-log |
+---------------+----------------+
1 row in set (0.00 sec)
mysql> revoke all privileges on *.* from user3;
Query OK, 0 rows affected (0.00 sec)
mysql> show grants for user3;
+-----------------------------------+
| Grants for [EMAIL PROTECTED] |
+-----------------------------------+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+-----------------------------------+
1 row in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.09 sec)
mysql> show grants for user3;
+-----------------------------------+
| Grants for [EMAIL PROTECTED] |
+-----------------------------------+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+-----------------------------------+
1 row in set (0.00 sec)
mysql> show variables like 'version';
+---------------+----------------+
| Variable_name | Value |
+---------------+----------------+
| version | 4.0.21-Max-log |
+---------------+----------------+
1 row in set (0.00 sec)
what am I doing wrong?
Thanks,
--
Nico Sabbi - Officine Digitali - Bologna
Tel. 051 - 4187565
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
