Bug #756 SHOW DATABASES & privileges
Submitted: 30 Jun 2003 4:34 Modified: 1 Aug 2003 12:57
Reporter: Pavol Cvengros Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.13 OS:Linux (Mandrake Linux 9.1)
Assigned to: CPU Architecture:Any

[30 Jun 2003 4:34] Pavol Cvengros 
Description:
Hello, 
 
I have problem, after upgrade to MySQL 4.0.13 I have this problem: 
 
even I set to standard user privileges SHOW DATABASE and CREATE TEMPORARY 
TABLES, they can see all databases with SHOW DATABASES command. 

How to repeat:
-
[1 Jul 2003 12:57] Indrek Siitan 
Could you elaborate, what exactly do you consider a bug?

If you grant the user SHOW DATABASES privileges, then yes, the user will see all the available 
databases with the SHOW DATABASES command - that's exactly what this grant is for. If that is not 
granted, then the user will see just the databases he has access to.
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".