Bug #10819 SHOW DATABASES privilege always ignored
Submitted: 24 May 2005 8:56 Modified: 26 May 2005 13:31
Reporter: Eugene Radchenko Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.11 OS:FreeBSD (FreeBSD)
Assigned to: CPU Architecture:Any

[24 May 2005 8:56] Eugene Radchenko 
Description:
This is Bug #3414 revisited.
Maybe the problem is not with the documentation only.
Most users have only CREATE TEMPORARY TABLES and LOCK TABLES global priviledges (though removing LOCK TABLES does not help) and DB priviledges for one DB only. However, SHOW DATABASES shows them all databases on server.

How to repeat:
Databases were originally 3.23. Server upgraded with a stock package of 4.1.11 for FreeBSD and the problem appeared. mysql_fix_priviledge_tables did not help.
[26 May 2005 13:31] MySQL Verification Team 
Hello,

Thank you for the report, but this is not a bug.
Users have global privilege (CREATE TEMPORARY TABLE) that allows them to create temporary tables in any database. That is why they can see all databases.
[26 May 2005 16:46] Eugene Radchenko 
Any reason why mysql_fix_priviledge_table creates those priviledges for all users? Will I lose any functionality (joins?) if those priviledges are removed? According to manual, until you run the utility, users would be able to see all databases. This would imply that they wouldn't afterwards, right? =)
BTW the manual section on priviledges (especiall global/administrative/newer ones) could benefit from some expansion. Right now it does not explain much to anyone who does not know most of the answer already.