Skip to main content
Question

A Role for the support

  • November 30, 2022
  • 1 reply
  • 6 views
shekhar8249

Hi Team,

Looking if there is a possibility of having role similar to sysmonitor. Don't want to assign sysmonitor role to the support team.

Most of the system tables would be already accessible if the user/id has an account in Vertica, but they can only query and get the results of their own queries run. I would like to have a role created separately assign the same to the ID by which they should be able to see all the queries/memory consumed/locks on the whole database?

Is there an option as such, please let me know. Thanks in advance.

Thanks,
Shekhar

    1 reply

    mosheg
    Forum|alt.badge.img+2
    • mosheg
    • Participating Frequently
    • December 1, 2022

    If you don't want to GRANT SYSMONITOR TO SUPPORT_TEAM_ROLE;
    You can maintain a copy of QUERY_REQUESTS as a separated table repository: QUERY_REQUESTS_ARCHIVE
    And grant SELECT on QUERY_REQUESTS_ARCHIVE to SUPPORT_TEAM_ROLE;

    The advantage is that you have full GRANT control on QUERY_REQUESTS_ARCHIVE
    For example you can CREATE ACCESS POLICY ON QUERY_REQUESTS_ARCHIVE
    And it will hold all historic info with no relation to the Data Collector retention policy.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement