As told, the two database will be on different servers.
Maybe the best solution is to create a linked server on the destination server. Then on the destination database create a view like servername.database.dbo.table.
This way users can query this view on the destination database without having permissions on the source database.
Can I create an HTTP linked server?