The user/group will have a select permission on the source table, does not matter if they connect to database A or database B, they can only select from the table and in the source database, they can only see that table. Unless one starts to implement a stored procedure to encapsulate (execute as) the object, this is the most straight forward method.
😎As there is no need for using a four part identifier, this solution "contains" things 😉
Not gunna lie, you lost me there Eirikur. :hehe: Perhaps some T-SQL will speak "louder" than words; could you show an example please?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk