Remediation
From Google Cloud Consoleβ
- Go to
BigQuery
by visiting: https://console.cloud.google.com/bigquery. - Select the dataset from
Resources
. - Click
SHARING
near the right side of the window and selectPermissions
. - Review each attached role.
- Click the delete icon for each member
allUsers
orallAuthenticatedUsers
. On the popup clickRemove
.
From Google Cloud CLIβ
List the name of all datasets.
bq ls
Retrieve the data set details:
bq show --format=prettyjson PROJECT_ID:DATASET_NAME > PATH_TO_FILE
In the access section of the JSON file, update the dataset information to remove all roles containing allUsers
or allAuthenticatedUsers
.
Update the dataset:
bq update --source PATH_TO_FILE PROJECT_ID:DATASET_NAME