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: 

Forum Posts

Start a conversation
shan_chandra
by • Databricks Employee
  • 2899 Views
  • 1 replies
  • 4 kudos

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

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

Warehousing & Analytics
Reply
  • 2899 Views
  • 1 replies
  • 4 kudos
View Replies
Latest Reply
shan_chandra
Databricks Employee
  • 4 kudos

Please find the below resolutionThe owner of the table needs to be the same as the owner of the ViewCreate a group with users for whom we require only access to the viewThe group needs to have SELECT and READ_METADATA on view(database2.view1), USAGE ...

  • 4 kudos
Labels