Post reply

Allow domain user read access to a database

  • September 15, 2008 at 9:59 am

    #192761

    Hi Guys. I cant seem to add a domain user to the security users in a database I am working on. Does anyone know how I would go about doing this?

  • September 15, 2008 at 10:23 am

    #871894

    From object explorer, expand out security (under the server), right click, choose new login. Make sure windows authentication is selected. Under login name enter the domain and user name - MyDomain\SomeUser

    Go to the user mapping tab and assign the new login to whatever DB it needs access to.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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