MySQL Forums
Forum List  »  MySQL Administrator

REVOKE GRANT
Posted by: takao yosiki
Date: October 07, 2005 01:34AM

I Cannot REVOKE GRANT.

I sow GRANT and REVOKE syntax.

GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY 'password']
[, user_name [IDENTIFIED BY 'password'] ...] [WITH GRANT OPTION]

mysql> grant usage on *.* to xxx@localhost width grant option;
TESTINT OK !!

REVOKE priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*} FROM user_name [, user_name ...]

mysql> revoke usage on *.* from xxx@localhost width grant option;
TESTINT NG !!

The person who had the same trouble as me was here.
--- MySQL Bugs: #2642: Error in REVOKE grammar ---
http://bugs.mysql.com/bug.php?id=2642

Please help.

Options: ReplyQuote


Subject
Written By
Posted
REVOKE GRANT
October 07, 2005 01:34AM
October 07, 2005 10:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.