Sample Header Ad - 728x90

What's the difference between ALL_TABLES and TABLES?

0 votes
1 answer
421 views
The docs are unenlightening: * [ALL_TABLES]: > Provides summary information about tables in a Vertica database. * [TABLES]: > Provides information about all tables in the database. The reason I'm asking is that users are confused about why they can see some tables in one but not the other. It's related to permissions, but it's not clear exactly how. For example, a user is telling me they have access to query a table. However, that table doesn't show up in TABLES and its columns don't show up in COLUMNS, but the table _does_ show up in ALL_TABLES. So, this leads to the following questions: 1. What's the difference between ALL_TABLES and TABLES? 2. How can users see a list of all the tables (and columns!) they have access to query?
Asked by Nick Chammas (14810 rep)
Aug 13, 2018, 04:37 PM
Last activity: Aug 13, 2018, 11:00 PM