MySQL Forums
Forum List  »  Security

REVOKE not honored
Posted by: rich
Date: January 07, 2011 05:57AM

host1$ mysql
mysql> # create database test, create table t with field f, insert two rows.
mysql> grant all on test.* to 'rich'@'host2' identified by 'dummy';

host2$ mysql -h host1 -urich -pdummy -Dtest -e 'SELECT * FROM t;'
+-------+
| f |
+-------+
| rich |
| test2 |
+-------+

***OK, this is as expected.****

host1$ mysql
mysql> revoke all privileges on test.* from 'rich'@'host2';
mysql> show grants for 'rich'@'host2';
+-----------------------------------------+
| Grants for rich@host2
------------------------------------------+
| GRANT USAGE ON *.* TO 'rich'@'host2' IDENTIFIED BY PASSWORD '...'
+-----------------------------------------+

**** OK, so far, BUT ****

host2$ mysql -h host1 -urich -pdummy -Dtest -e 'SELECT * FROM t;'

STILL gives results - there are now no privileges for rich@host2 on database test, but the user is able to receive the data!

I've tried FLUSH PRIVILEGES, I've even tried restarting the server; same problem exists. Somehow MySQL still thinks rich@host2 should be allowed access to test db.

Any help? I'm going mad here...

Options: ReplyQuote


Subject
Views
Written By
Posted
REVOKE not honored
3010
January 07, 2011 05:57AM


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.