Vertica monitoring user to access all system tables
Hi ,
I wanted to create a vertica monitoring user which will have access to all the system tables (v_catalog , v_monitor) . I created a user but it is fetching data with respect to that user only. dbadmin being the super user has privilege to access all the data from system table.
Is there any specific grant / role which has to be provided to monitoring user so that it fetches full data from system tables . Reason to create a new user is I do not want to run monitoring queries from dbadmin user.
Tried this but didn't work out.
CREATE ROLE monitor; # created role
GRANT dbadmin to monitor;
GRANT dbadmin to monitoring_user;
Select * from roles;
role_id name assigned_roles
45035996273704964 public
45035996273704966 dbduser
45035996273704968 dbadmin dbduser*
45035996273704970 pseudosuperuser dbadmin*
45035996273704972 sysmonitor
72057595877958608 monitor dbadmin, sysmonitor
Thanks in advance
Comments
Isn't the SYSMONITOR role what what you need?
See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/DBUsersAndPrivileges/Roles/SYSMONITORROLE.htm
Thanks Jim,
The mistake which I have done was i didn't enabled the role for monitoring_user.
After enabling monitor role this is fulfilling the purpose.
SET ROLE monitor;
Thanks Again