Big query iam policy bindings

[CLimachi1]

Hello,

I wanted to get a report in gcp for users that have policy bindings in bigquery tables but the results por iam and resource cloud manager doesn´t show me all the direct bindings only those from the IAM roles.

Is there a way to get that information in prisma?

[CloudEngineer]

Hi,

You can search for the results of all resources that are granted access to BigQuery by using the following RQL under the "Investigate" page. However you need to ensure that you are subscribed to our IAM module.

config from iam where source.cloud.type = 'GCP' AND dest.cloud.service.name = 'bigquery' will give you a good example and results to get started with what you're looking for. Then you can use the Graph or Table view to check your results in your preferred view.

I've attached a screenshot for reference:

Regards,