SELECT only access to SYSTEM tables

Sean_O_Riordan

Hi, I am creating a user for monitoring performance etc... How can I grant SELECT to the V_MONITOR and V_CATALOG tables? I can't do GRANT SELECT ON V_MONITOR.RESOURCE_QUEUES TO MONITOR_USER; The user needs SELECT privilege to the system tables and I don't want the user having Insert/Update/Delete privileges on any table. Thanks, Sean

Sajan_Sangraula

Hi Sean, Vertica system tables are read only anyways as they are meant to provide information rather than configure parameters. I dont think you would need to enforce any additional constraints. This documentation page has additional details that you may find helpful: https://my.vertica.com/docs/6.1.x/HTML/index.htm#8747.htm