List:General Discussion« Previous MessageNext Message »
From:Nico Sabbi Date:March 10 2005 3:46pm
Subject:Revoke all privileges on *.* doesn't work
View as plain text  
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 user3@%                         |
+--------------------------------------------+
| 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 user3@%                |
+-----------------------------------+
| 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 user3@%                |
+-----------------------------------+
| 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


Thread
Revoke all privileges on *.* doesn't workNico Sabbi10 Mar
  • Re: Revoke all privileges on *.* doesn't workJigal van Hemert10 Mar
  • Re: Revoke all privileges on *.* doesn't workSGreen10 Mar
RE: Revoke all privileges on *.* doesn't workChristian Caron10 Mar
  • Re: Revoke all privileges on *.* doesn't workNico Sabbi10 Mar
    • MAX_JOIN_SIZE error. 4.0 v 4.1Brett Harvey10 Mar
      • Re: MAX_JOIN_SIZE error. 4.0 v 4.1SGreen10 Mar
      • Re: MAX_JOIN_SIZE error. 4.0 v 4.1Sergei Golubchik10 Mar
RE: Revoke all privileges on *.* doesn't workPaul DuBois10 Mar