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
1846
June 28, 2017 08:09PM
587
June 28, 2017 11:10PM
609
June 30, 2017 01:53AM
778
June 30, 2017 02:31AM
618
June 30, 2017 10:27AM
645
July 03, 2017 11:32PM
570
June 29, 2017 01:35AM
Re: SHOW TABLES producing empty result set
619
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.