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
1853
June 28, 2017 08:09PM
591
June 28, 2017 11:10PM
612
June 30, 2017 01:53AM
781
June 30, 2017 02:31AM
621
June 30, 2017 10:27AM
648
July 03, 2017 11:32PM
573
June 29, 2017 01:35AM
623
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.