SHOW TABLES producing empty result set
Hi,
According to the 5.6 Ref on the SHOW TABLES command, you should be able to see the tables for which you have access when issuing that command. That does not seem to be the case where I have a user with SELECT, UPDATE, INSERT & DELETE privs on 4 tables in a database, and yet SHOW TABLES issued by that user in that database produces an empty result set. Can anyone tell me why this would be the case?
Thanks,
GAM (Glen A McAllister)
Subject
Views
Written By
Posted
SHOW TABLES producing empty result set
2004
June 28, 2017 08:09PM
641
June 28, 2017 11:10PM
668
June 30, 2017 01:53AM
903
June 30, 2017 02:31AM
692
June 30, 2017 10:27AM
729
July 03, 2017 11:32PM
630
June 29, 2017 01:35AM
674
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.