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

krishnamraju

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

Jim_Knicely

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)

krishnamraju

Jim Thanks for the revert.

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