Granting Access to view system queries in History GUI

Questions : Granting Access to view system queries in History GUI

536

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

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

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

Total Answers 1
32

Answers 1 : of Granting Access to view system queries in History GUI

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

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

Top rated topics

Get-Printer cmdlet applied to multiple remote servers

Firebase Deploy Error while deploying functions

SingleLogout doesn’t work when session timeout in SP

Get nested data out of URQL Svelte Store - Cannot read property

Why is "AppleSequencer" limited to 280.00 BPM?

D3JS how to get the y postition with bisector?

How can I add a label widget after the main window has been initialized?

Terraform data source external with bash script throwing error with JSON structure

Using gp_segment_id as the partition column to get data from greenplum in parallel

Convert Base64 of a PNG in to RGB values of each individual Pixel using Scratch.mit?

How to call a class method "display" in such a situation

Jwt verification fails by Envoy

Provide token with Angular pre-render

Migration .NET Core 2.2 to .NET Core 3.1- LINQ LEFT JOIN - Calling Take() on DefaultIfEmpty does not translate to server side SQL

Azure Functions 3.1 .NET Core HttpResponse changing case on serialized object

Google Fonts - variable fonts not working in Windows browsers

ActionContext.getContext() returns null using Session in Struts 2

Android BLE onScanResult is never called in the background on Android 11. Was working on Android 10

How to generate auth 2.0 in karate I saw a sample in karate Demo project but in our case we need to send it as "Authorization Code"

How to execute a command inside a singularity container that do not interact/sources options from the host OS?

Efficient element-wise vector times matrix ,multiplication in MKL

How to generate secp256k1 signature using private key in HEX format

How to use Firebase Extension Translate Text in Firestore inside a field that contain array?

Weighted sum of several vector similarity correctly in AWS Elasticsearch 7.10,

Remove line break in generated PDF (using jsPDF)?

Parameter Passing in HTML

Flutter - Execution failed for task ':cloud_firestore:compileDebugJavaWithJavac'

SQLAlchemy aggregate count column most frequent value per group

Origin point of application insights data in Azure?

What is the difference between the event loop in JavaScript and async non-blocking I/O in Node.js?

Could and how update cpu features flags in linux for openstack live migrate instance

Unable to start process. Timeout waiting for child process to open named pipes

Interpolate NA values with the mean for each row but only for one or two NA values between numerical values

Why isn't get_query_var returning my custom query vars?

Openssl check fails with Private key for terraform oci provider

Azure KeyVault signature fails during verification using javascript libraries intermittently

How do I copy files to another root directory in Azure Devops release pipelines?

How do I make "npm run start" exit with a code 0?

Install Rdkit in jupyter notebook, using Anaconda enviornment

Handling assembly files in Makefile - include statement problem?

Python dataframe or hiveSql update based on predecessor value?

OAuth2AccessTokenResponse should allow adding "expiresAt" to OAuth2RefreshToken

Apache Server Restrict user in OIDC authentication

Plotting multiple dataframes in a single list on 3d plots python

How can I leverage Prisma's implicit relations to create the following relation? (one-many, many-many, one-one)

Errorr in node:internal/modules/cjs/loader:488

HERE-API using eval and New Function (REPOST)

Intellij is not using settings in MAVEN_OPTS environment variable to build the project

How to extract multivalue fields from db2 database onto a relational database

Forward stdout bytes from Process to WebSocket or read current InputStream length

Top