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

krishnamrajukrishnamraju Community Edition User
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


  • Options
    Jim_KnicelyJim_Knicely - Select Field - 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:

    [dbadmin@vertica7 ~]$ 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)
  • Options
    krishnamrajukrishnamraju Community Edition User

    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