MySQL Forums
Forum List  »  Security

Re: SHOW TABLES producing empty result set
Posted by: Glen McAllister
Date: June 29, 2017 11:33PM

Hi George,

I thought my original post was pretty clear about how you would reproduce the problem, or at least what was done before encountering the problem; i.e. give a user access to a subset of tables in a database and then see if they could get a non-null output on a SHOW TABLES command in that database.

Anyway - I followed your advice and tried to reproduce the problem in my test instance and here the results were as expected; i.e. SHOW TABLES gave as output the tables the user had access to. In light of this, does this point to mysql.tables_pr(i)v being corrupted as Peter suggested?

Options: ReplyQuote

Written By
Re: SHOW TABLES producing empty result set
June 29, 2017 11:33PM

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.