A Role for the support

shekhar8249shekhar8249 Community Edition User

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

Answers

  • moshegmosheg Vertica Employee Administrator

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file