How to provide read access only to the view in DBSQL and not the underlying table?

shan_chandra
Databricks Employee
Databricks Employee

‎04-08-2022 11:03 AM - last edited on ‎03-20-2025 09:59 AM by Community Manager

Facing the below error

User cannot select on table `database2.view1` because:
There is no owner for table `database1.table1`. Ask your administrator to set an owner."

 

Labels:

shan_chandra
Databricks Employee
Databricks Employee

‎04-08-2022 11:10 AM

Please find the below resolution

  1. The owner of the table needs to be the same as the owner of the View
  2. Create a group with users for whom we require only access to the view
  3. The group needs to have SELECT and READ_METADATA on view(database2.view1), USAGE on the database containing the view(database2)

View solution in original post