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
2341
June 28, 2017 08:09PM
709
June 28, 2017 11:10PM
754
June 30, 2017 01:53AM
1121
June 30, 2017 02:31AM
755
June 30, 2017 10:27AM
822
July 03, 2017 11:32PM
711
June 29, 2017 01:35AM
Re: SHOW TABLES producing empty result set
770
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.