The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
view all query log - v_monitor.query_profiles
Hi,
When I query table v_monitor.query_profiles
I see only the queries that I ran.
Is it possible to grant permissions to view queries that ran by all users? (without adding my user as a super user).
Thanks
0
Comments
Hi,
You can grant the SYSMONITOR role a user to give it access to system tables without granting full DBADMIN access.
QUERY_PROFILES is a system table that is monitorable.
See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Security/DBUsersAndPrivileges/SYSMONITORROLE.htm
Example:
Thanks!