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

[shan_chandra]

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."

[shan_chandra · Accepted solution]

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)