Skip navigation links

MySQL Forums :: Security :: Grant NO PRIVILEGES and SELECT allowed anyway


Advanced Search

Grant NO PRIVILEGES and SELECT allowed anyway
Posted by: Giovanni Gasparri ()
Date: February 24, 2011 08:58AM

Hi everybody,
I have a user having the following grants:

GRANT USAGE ON *.* TO 'example'@'%' IDENTIFIED BY PASSWORD 'hjga'
GRANT SELECT ON `mydb`.* TO 'example'@'%'

Then when I log in I can view all databases, all tables and I can even select records from all databases, and not only from mydb.

What happens?

I'm running
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2

Options: ReplyQuote


Subject Views Written By Posted
Grant NO PRIVILEGES and SELECT allowed anyway 3427 Giovanni Gasparri 02/24/2011 08:58AM
Re: Grant NO PRIVILEGES and SELECT allowed anyway 1191 Giovanni Gasparri 03/01/2011 02:23AM


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.