CODEWITHSUNDEEP
google-bigquerygoogle-cloud-iamgoogle-logginggcp-stackdriver
Dinesh
Dinesh

Reputation: 327

How to map permissions to roles

Permission denied. Please get bigquery.jobs.listExecutionMetadata or bigquery.jobs.listAll permission at organisation level to access Admin Resource Charts.

I am getting the above error while trying to access the Monitoring dashboard in BigQuery.

Question: How do I find which role has these permissions so that role can be assigned to principle ?

Thanks in advance for your help

Upvotes: 0

Views: 1180

Answers (1)

Jose Gutierrez Paliza
Jose Gutierrez Paliza

Reputation: 1428

You need to set some roles at the organization level. Applying them to the organization level means that you provide permission to access all of a project’s BigQuery resources. These roles are used at the organization level because BigQuery Monitoring requires it.

The predefined BigQuery roles with these permissions are:

  • BigQuery Admin
  • BigQuery Resource Admin
  • BigQuery Resource Editor
  • BigQuery Resource Viewer

On the other hand, if you have these roles and BigQuery Monitoring is still giving you the same error, you probably have the roles set at a project level, applying them to a project level means you will only have access to that project.

These are the required permissions to use BigQuery Monitoring. See this to know how to grant permissions at organization level.

Additionally, you can see all the BigQuery Roles in this document.

Upvotes: 1

Related Questions