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."
- 2849 Views
- 1 replies
- 4 kudos
Latest Reply
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