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.

Regards
Krishnam Raju

Answers

  • Jim_KnicelyJim_Knicely - Select Field - Administrator

    Hi,

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

    See:
    https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/NewFeatures/_VersionIndependent/DeprecatedandRetiredFunctionality.htm

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

    See:
    https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/Security/SystemTableRestriction.htm?

    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();
                   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)
    
  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file