• Eirikur Eiriksson - Monday, February 4, 2019 7:41 AM

    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