How to restrict the table/view access in Bigquery?

Question

Suppose I have 2 users available for the same project. The requirement is to restrict the table access in the same project to one user. How can it be managed it in Bigquery? what kind of access controls to be applied and how?

Thanks in advance.

Answer 1

You can use table level ACLS and set Bigquery roles/bigquery.dataViewer for users on the tables you wish to grant access. More details here https://cloud.google.com/bigquery/docs/table-access-controls-intro

This approach doesn't require creating a separate dataset(as a workaround for table level access) for access control which use to be the case earlier.