Restrict access to source table and view

I need restrict access to view and its source table.

I have a source Table A and a view B created on the basis on source table A.

I need to to give user access to specific view and its source table only.

Is it possible ?

6 2 81
2 REPLIES 2

Absolutely.  See the following documentation.  You can control access to datasets, tables and views using the Identity and Access Management (IAM) capabilities.  Using this, you can give access to specific users and groups.  If what you are controlling access to is a view that restricts the columns on a table, you can use authorized views to declare that a user can query the view but not be granted access to the table on which the view is based.

I have to tables A and B. For each table has its view.

I need to give access to table A and its view only for one user

For other user will only have access to table B and its view.