A Role for the support

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

mosheg

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.