Post reply

Limited Access to Link Server

  • January 8, 2009 at 6:38 am

    #133575

    How can i limit access through Link Server which is a sql login.

    I have ServerA and ServerB and users X,Y,Z. All 3 users can read DB1 on ServerB from serverA through a sql login Link " DevLink" but I would like to restrict access to user Y on database DB1 but could not do it as DevLink will give read access to that user by default.

  • January 8, 2009 at 7:41 am

    #923317

    You have to use individual logins for your linked server. You can make two logins on ServerB and from the GUI for the linked server, you can map users X and Z to one login and user Y to the other login. Then restrict the second login on ServerB.

    Was that vague enough?

    It gets handled in the linked server user dialog (screen print attached).

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply