Update user permissions

Hi there.

I am using bigquery as my database to pull data on a schedule from google sheets. I got this email about Review and update user permissions to create or update a transfer configuration. Seems like I need to update my permissions to this. bigquery.datasets.setIamPolicy and bigquery.datasets.getIamPolicy
I am not sure how, or if I have to and my console plan does not allow support.

Can anyone assist or point me in the right direction please?

Thanks

2 Likes

To create or update a BigQuery transfer, you need bigquery.datasets.setIamPolicy and bigquery.datasets.getIamPolicy on the dataset. You can update permissions in the Google Cloud Console under IAM & Admin → IAM, or via gcloud using:

gcloud projects add-iam-policy-binding PROJECT_ID
–member=“user:YOUR_EMAIL”
–role=“roles/bigquery.dataEditor”

If you lack permissions, ask your project admin to grant them. Once applied, you can create or update transfer configs.

Many Thanks, the Admin leaves it all to me, and she doesnt know how to do this. If I can screenshare with her, how and where do I update my permissions?