Re: SHOW TABLES producing empty result set
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?
Subject
Views
Written By
Posted
2505
June 28, 2017 08:09PM
762
June 28, 2017 11:10PM
810
June 30, 2017 01:53AM
1260
June 30, 2017 02:31AM
801
June 30, 2017 10:27AM
881
July 03, 2017 11:32PM
760
June 29, 2017 01:35AM
Re: SHOW TABLES producing empty result set
813
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.