#3773 No tables shown because of privileges of views

[Marc Delisle]

(Old tracker 3601233)
I have a problem with one database. I have imported it with a backup script and everything worked fine. But phpMyAdmin does not show any tables in the left navigation although there are a lot. And there was no error message. When I execute "SHOW TABLES FROM database_xyz;" all tables are shown.

I have debugged the code of phpMyAdmin and found out, that the query, which should load the table information, failed:
phpMyAdmin executes this query: SHOW TABLE STATUS FROM mydatabasename;
Th error is: ERROR 1143 (42000): SELECT command denied to user ''@'192.168.55.%' for column 'method' in table 'sales_flat_order_payment'

The reason is a privilege problem of some views (see MySQL bugtracker http://bugs.mysql.com/bug.php?id=63527#c394325 ). But that is not important for phpMyAdmin.
It would be nice if phpMyAdmin could show the error message to the user (maybe with the hint that it may be a privilege issue with one of the existing views). So that the user is able to search for a solution.

[Marc Delisle]

Is sales_flat_order_payment a table or a view?

[csnaitsirch]

Hi Marc. sales_flat_order_payment is a normal table. That is what has confused me the most ;-) You can read my last comment on http://bugs.mysql.com/bug.php?id=63527#c394325

[Madhura Jayaratne]

I am unable to reproduce the problem with QA_4_3.

I created an unprivileged user who has all privileges except select for sakila database.
When I log in to phpMyAdmin, the navigation is properly populated. I can visit all the database level tabs and all the table level tabs except Browse (and Insert). As expected I get
#1143 - SELECT command denied to user 'abcd'@'localhost' for column 'actor_id' in table 'actor'
error message.
SHOW TABLE STATUS FROM sakila; also executes without a problem.

[csnaitsirch]

Thanks for your response. I have tested it in version 4.2.10.1deb1 and now it works as you said ;-)

Thanks. Bug can be closed.