MySQL Forums
Forum List  »  Newbie

Revoke privileges from user issue!
Posted by: Scott Pichelman
Date: August 01, 2011 01:09PM

Hi,

I've been trying to figure out how to revoke grants from a user called tempaccess...

I've tried to revoke all privileges.
And separate privileges as wel with no luck.
And flushed privileges too.

However - I can remove via the SQL Administrator - but the Command line show that the user still has grants!?!

What can i be missing here?


#############################################################
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 46
Server version: 5.1.39-community MySQL Community Server (GPL)
#############################################################


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mysql;
Database changed

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| xxx |
| test |
+--------------------+
4 rows in set (0.00 sec)

mysql> use xxxi;
Database changed

mysql> SHOW GRANTS FOR tempaccess@"%";
+-------------------------------------------------------------------------------
----------------------------+
| Grants for tempaccess@%
|
+-------------------------------------------------------------------------------
----------------------------+
| GRANT USAGE ON *.* TO 'tempaccess'@'%' IDENTIFIED BY PASSWORD '*2802BB99546BDE
1C380E3C3C5DEA5C0507CE9A63' |
+-------------------------------------------------------------------------------
----------------------------+
1 row in set (0.00 sec)




mysql> REVOKE INSERT,UPDATE,DELETE ON *.* FROM tempaccess@%;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '%' at
line 1

mysql> REVOKE INSERT,UPDATE,DELETE ON *.* FROM tempaccess@'%';
Query OK, 0 rows affected (0.05 sec)

mysql> REVOKE INSERT,UPDATE,DELETE ON *.* FROM tempaccess@"%";
Query OK, 0 rows affected (0.02 sec)

mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@"%";
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'%'

mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@"localhost";
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'localhost'

mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@"192.168.1.11";

ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'192.168.1.11'

mysql> REVOKE INSERT,UPDATE,DELETE ON xxx.* FROM tempaccess@'%';
ERROR 1141 (42000): There is no such grant defined for user 'tempaccess' on host
'%'



Any ideas are greatly appreciated.

Thx.

-SP

Options: ReplyQuote




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.