I have created a view in dbadmin and that granted one user to access that view....
But its not fetching the data from that view.
I have granted the permission to the user also.....
grant select on dbadmin.topfive to canary1 with grant option;
It might be that the view does not have permissions to select from another database. Is it throwing a permissions error is just not pulling back any rows?