cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Help
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

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

Go to solution
shan_chandra
Databricks Employee
Databricks Employee

โ€Ž04-08-2022 11:03 AM

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:
1 ACCEPTED SOLUTION

Accepted Solutions

Go to solution
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

1 REPLY 1

Go to solution
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)

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group
Announcements