Post reply

linked server

  • December 18, 2005 at 8:53 pm

    #167393

    HI,

     

    I had a  login in sql server in a default database.I configured a linked server and i want to ristrict that user not to access that linked server.

     

    How can i do this,

     

     

    from

    killer

  • December 20, 2005 at 9:04 am

    #610614

    When you define the linked server, you can leave the login mapping blank, and select "Be made using the login's current security context"

     

    If other users do not have permissions to access the phsical server (the linked server), then they cannot access data via the linked server too.

     

  • December 20, 2005 at 8:31 pm

    #610756

    Thanx for ur reply.

    But i did it myself.

     

    from

    Killer

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

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