CODEWITHSUNDEEP
google-iamgoogle-cloud-iam
andyh123
andyh123

Reputation: 21

How to restore permission when I am the admin of the project?

After mistakenly add myself to a wrong role, I am no longer able to access "IAM & admin".

While trying to extract Big Query tables to Google Storage, I received the following error,

bq extract --compression GZIP Dataset.TableName gs://tableName_*.csv.gz
Waiting on bqjob_r4250d44ecf982a22_00000169c666b451_1 ... (23s) Current status: DONE
BigQuery error in extract operation: Error processing job 'Dataset:bqjob_r4250d44ecf982a22_00000169c666b451_1': Access Denied: BigQuery BigQuery: Permission denied while writing data.

I thought I may have a permission issue, therefore I change my role in Google Cloud. I don't remember what role I changed. It may be owner or creator.

After that, I am not able to to access the project in Big Query, as well as "IAM & Admin" page.

bq extract --compression GZIP Dataset.TableName gs://tableName_*.csv.gz
BigQuery error in extract operation: Access Denied: Project projectName: The user [email protected] does not have bigquery.jobs.create permission in project projectName.

Since I am the admin of this account, there is no other person who has the access. What options do I have to restore the access?

Thank you in advanced.

Upvotes: 2

Views: 354

Answers (1)

Hunter Golden
Hunter Golden

Reputation: 11

For this case, please open a case through the billing support form, and for "How can we hep?" select "other." https://support.google.com/cloud/contact/cloud_platform_billing

This way, I can follow up with you in private and get the details necessary to move forward. Please let me know once you submit the case and what your case number is so I can follow up.

Edit: For anyone else viewing this issue, the above method is just for this case and not the correct avenue of support for this problem. If you have a support package and you have this issue, please reach out through normal channels.

Thanks,

Hunter, GCP Billing

Upvotes: 1

Related Questions