Skip to main content

SELECT only access to SYSTEM tables

  • June 18, 2013
  • 1 reply
  • 6 views
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

    1 reply

    Sajan_Sangraula
    Forum|alt.badge.img+1
    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
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement