A Role for the support
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.