MySQL Forums
Forum List  »  Security

SHOW TABLES producing empty result set
Posted by: Glen McAllister
Date: June 28, 2017 08:09PM

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?


GAM (Glen A McAllister)

Options: ReplyQuote

Written By
SHOW TABLES producing empty result set
June 28, 2017 08:09PM

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.