Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How users will get own scheme tables list, if system table access is restricted ?

edited March 2018 in General Discussion
We have restricted system table access for normal users with RestrictSystemTable parameter. After this users are not able to get their own tables list from tables(system table).. But they are able see the list which they got select access.

Krishnam Raju


  • Jim_KnicelyJim_Knicely Administrator


    Fyi... The RestrictSystemTable parameter has been deprecated in Vertica 9.0.1:


    There are now 2 new cool functions that let you restrict and open access to system tables for a given session:


    What version of Vertica are you using? Is it 7.2.3-15 which I saw in one of your other posts?

    If so, I'm not seeing this issue in 7.2.3-26... That is, I can see my tables (user = jim) in the TABLES system table even when the DB is locked down:

    [[email protected] ~]$ vsql -U jim
    Welcome to vsql, the Vertica Analytic Database interactive terminal.
    Type:  \h or \? for help with vsql commands
           \g or terminate with semicolon to execute query
           \q to quit
    jim=> select version();
     Vertica Analytic Database v7.2.3-26
    (1 row)
    jim=> show current RestrictSystemTables;
      level   |         name         | setting
     DATABASE | RestrictSystemTables | 1
    (1 row)
    jim=> select table_schema,table_name, owner_name from tables;
     table_schema | table_name | owner_name
     public       | jim_test   | jim
    (1 row)
  • Jim Thanks for the revert.

    Yes we are on vertica version 7.2.3-15.
    We are planing for upgrade.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.