Post reply

link server

  • March 22, 2011 at 11:57 am

    #235573

    if iam creating a link server between 2 sql server using sql login, how can i give a user full access to a destination database but not others.

  • March 22, 2011 at 12:14 pm

    #1302071

    Tara the other person could be mapped to a remote user that has full access, and everyone else's connection made with no context; that way, everyone EXCEPT the people i've mapped try to use anonymous credentials and fail.

    here for example is a screenshot:

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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