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
From: Nico Sabbi
mysql show grants for user3;
+---+
| Grants for [EMAIL PROTECTED]|
+---+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+---+
1 row in set (0.00 sec)
what am I doing
Nico Sabbi [EMAIL PROTECTED] wrote on 03/10/2005 10:46:37 AM:
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
mysql show grants for user3;
+---+
| Grants for [EMAIL PROTECTED]|
+---+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+---+
1 row in set (0.00 sec)
what am I doing wrong?
At 11:01 -0500 3/10/05, Caron, Christian wrote:
mysql show grants for user3;
+---+
| Grants for [EMAIL PROTECTED]|
+---+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+---+
1 row
Caron, Christian wrote:
mysql show grants for user3;
+---+
| Grants for [EMAIL PROTECTED]|
+---+
| GRANT USAGE ON *.* TO 'user3'@'%' |
+---+
1 row in set (0.00 sec)
what am I doing