I have a backup role BACKUP_ROLE set up to allow a contractor to view our systems overnight and diagnose any problems that arise. I do not want to give it SYSADMIN or ACCOUNTADMIN privileges, but I would like BACKUP_ROLE to have access to view system queries in the history tab of the GUI.

I need them to click the "Include Queries executed by user tasks" and show these system queries listed below.

What permissions do I need to add to BACKUP_ROLE to make this work?

CodePudding user response：

Grant "Monitor" privilege on the Warehouse to the role as follows:

grant MONITOR  on warehouse <WH name> to role BACKUP_ROLE;