Skip to main content
Question

Is there a way in Vertica for a user to query v_catalog?

  • May 8, 2020
  • 1 reply
  • 5 views

rahul

I need to give users permission to view all the column names, tables names etc across all the schema's, so is it possible to give them permissions to v_catalog.columns, v_catalog.tables etc.

1 reply

LenoyJ
Forum|alt.badge.img+1
  • Participating Frequently
  • May 8, 2020

Assign SYSMONITOR role to the user? https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/DBUsersAndPrivileges/Roles/SYSMONITORROLE.htm
However, this also gives access to read all system tables as well. You can verify by the following query:

select table_name, is_monitorable from system_tables where table_name='current_session';
table_name       | is_monitorable
--------------------------------
current_session  | t

The t in the is_monitorable column indicates the current_session system table is accessible by the SYSMONITOR.