Assign access control to a BigQuery Dataset

0 votes
What's the mechanism for controlling access to a dataset? Can I configure access controls at the time of creation of dataset itself?
Nov 15, 2019 in GCP by anonymous
• 6,260 points
1,621 views

1 answer to this question.

0 votes

You can apply access controls during dataset creation by calling the datasets.insert API method.

Access controls cannot be applied during dataset creation in the GCP Console, the classic BigQuery web UI, or the command-line tool.

To assign access controls to a dataset using the console:

  1. Select a dataset from Resources, then click Share dataset near the right side of the window.

  2. In the Share dataset panel, in the Dataset permissions tab, click Add members.

  3. In the Add members panel, enter the entity you want to add into the New members text box. You can add any of the following entities:

    • Google account e-mail: Grants an individual Google account access to the dataset

    • Google Group: Grants all members of a Google group access to the dataset

    • Google Apps Domain: Grants all users and groups in a Google domain access to the dataset

    • Service account: Grants a service account access to the dataset

    • Anybody: Enter "allUsers" to grant access to the general public

    • All Google accounts: Enter "allAuthenticatedUsers" to grant access to any user signed in to a Google Account

  4. For Select a role, select BigQuery and choose an appropriate pre-defined IAM role for the new members.

  5. Click Done.

answered Nov 15, 2019 by Sirajul
• 59,230 points

Related Questions In GCP

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Can I give a user access to cloud storage who doesn't have a GCP account?

Yes, you could certainly do this.  You can ...READ MORE

answered Nov 5, 2019 in GCP by Sirajul
• 59,230 points
791 views
0 votes
2 answers
0 votes
1 answer

Permissions required to update a dataset.

At a minimum, to update dataset properties, ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 59,230 points
1,554 views
0 votes
1 answer

Change default expiration time for a dataset.

You can update a dataset's default table ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 59,230 points
1,520 views
0 votes
1 answer

Using a JSON Schema file in BigQuery for creating a Schema.

After creating your JSON schema file, you ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 59,230 points
6,527 views
0 votes
1 answer

How can i grant access to a GCP project for a large scale multiple users at once?

gcloud auth to service accounts is allowed. ...READ MORE

answered Oct 16, 2019 in GCP by Sirajul
• 59,230 points
1,121 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP