https://community.databricks.com/t5/warehousing-analytics/how-to-provide-read-access-only-to-the-view-in-dbsql-and-not-the/m-p/23223#M553 <P>Facing the below error</P> <PRE><CODE>User cannot select on table `database2.view1` because: There is no owner for table `database1.table1`. Ask your administrator to set an owner."</CODE></PRE> <P>&nbsp;</P> Thu, 20 Mar 2025 16:59:06 GMT shan_chandra 2025-03-20T16:59:06Z https://community.databricks.com/t5/warehousing-analytics/how-to-provide-read-access-only-to-the-view-in-dbsql-and-not-the/m-p/23223#M553 <P>Facing the below error</P> <PRE><CODE>User cannot select on table `database2.view1` because: There is no owner for table `database1.table1`. Ask your administrator to set an owner."</CODE></PRE> <P>&nbsp;</P> Thu, 20 Mar 2025 16:59:06 GMT https://community.databricks.com/t5/warehousing-analytics/how-to-provide-read-access-only-to-the-view-in-dbsql-and-not-the/m-p/23223#M553 shan_chandra 2025-03-20T16:59:06Z https://community.databricks.com/t5/warehousing-analytics/how-to-provide-read-access-only-to-the-view-in-dbsql-and-not-the/m-p/23224#M554 <P>Please find the below resolution</P><OL><LI>The owner of the table needs to be the same as the owner of the View</LI><LI>Create a group with users for whom we require only access to the view</LI><LI>The group needs to have SELECT and READ_METADATA on view(database2.view1), USAGE on the database containing the view(database2)</LI></OL> Fri, 08 Apr 2022 18:10:35 GMT https://community.databricks.com/t5/warehousing-analytics/how-to-provide-read-access-only-to-the-view-in-dbsql-and-not-the/m-p/23224#M554 shan_chandra 2022-04-08T18:10:35Z