MySQL Forums :: Newbie :: Revoke privileges from user issue!


Advanced Search

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


Subject Written By Posted
Revoke privileges from user issue! Scott Pichelman 08/01/2011 01:09PM
Re: Revoke privileges from user issue! Barry Galbraith 08/01/2011 04:11PM
Re: Revoke privileges from user issue! Scott Pichelman 08/02/2011 09:53AM
Re: Revoke privileges from user issue! Guelphdad Lake 08/02/2011 10:02AM
Re: Revoke privileges from user issue! Scott Pichelman 08/02/2011 10:07AM
Re: Revoke privileges from user issue! Guelphdad Lake 08/02/2011 11:36AM
Re: Revoke privileges from user issue! Scott Pichelman 08/02/2011 12:21PM
Re: Revoke privileges from user issue! Guelphdad Lake 08/02/2011 12:29PM
Re: Revoke privileges from user issue! Scott Pichelman 08/02/2011 12:58PM
Re: Revoke privileges from user issue! Rick James 08/13/2011 02:57PM
Re: Revoke privileges from user issue! Scott Pichelman 08/15/2011 07:08AM


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.