Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

User access to specific tables

Currently I have the demand to allow some specific users to just be able to access specific tables in BigQuery. The documentation is a quite confused for me, is there anybody with practical steps to set this up?

 

Thanks in advance.

Solved Solved
0 3 3,575
2 ACCEPTED SOLUTIONS

You can do this with Table ACLs, see https://cloud.google.com/bigquery/docs/table-access-controls-intro. If you are using the console, select the table in the SQL Explorer and select the Share button. You can give the user or group BigQuery Data Viewer permissions.

View solution in original post

3 REPLIES 3

You can do this with Table ACLs, see https://cloud.google.com/bigquery/docs/table-access-controls-intro. If you are using the console, select the table in the SQL Explorer and select the Share button. You can give the user or group BigQuery Data Viewer permissions.

You can refer this , well explained

https://youtu.be/hgKaYjy6Rd0

Good morning, is it possibile to share the table to the user without adding the user to the project?