Bug #12318 ERROR 42000: Unknown db 'information_schema' at call of a SP without privileges

Submitted:	2 Aug 2005 13:06	Modified:	17 Aug 2005 17:55
Reporter:	Carsten Segieth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.10a	OS:	Windows (Windows XP Home (german) SP 2)
Assigned to:	Jim Winstead	CPU Architecture:	Any

Description:
MySQL 5.0.10a shows the error message "ERROR 42000: Unknown database 'information_schema'" for a call of a stored procedure where the calling user has no privileges for this SP if the connection for this user has been made with specifying 'information_schema' as default database. 

If an other default database is specified the error message is OK ("ERROR 42000: execute command denied to user ..."), also the error message is OK ("command denied ...") when using a default db other than 'information_schema' to connect and later change to 'information_schema'.

How to repeat:
Run attached test script.

Suggested fix:
show a better error message.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28095

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/28202

Fixed in 5.0.12.

Noted in 5.0.12 changelog.

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.