I created a view
SchemaX.VW_VIEW on a DatabaseB. This view is querying data from another database DatabaseA of the same server.
I have granted the SELECT permission on
VW_VIEW to a user. However when the user tries to query the view, it says "The SELECT permission was denied on the object 'OriginTable', database 'DatabaseA', schema 'SchemaY'.
SchemaY and SchemaX are both owned by 'dbo' so there shouldn't be any break in the ownership chaining.
How can I fix this issue without granting read access to the underlying tables?