Home Forums SQL Server 2008 Security (SS2K8) Multiple logins to single DB group RE: Multiple logins to single DB group

  • October 12, 2013 at 9:59 am

    #1658076

    schleep (10/11/2013)

    Hi all,

    I'm wondering if it is possible to map multiple Windows groups logins to a single database user (which is in fact a group)?

    Scenario:

    DomainA\Agents

    DomainB\Agents

    each have logins. I would like them to both access the database DB_1 via the same user (group), say, App_Agents.

    A Windows-Group can be matched to a SQL Server Login which again an be matched to a User (not group) which then can be put into a database role.

    That's it. In short:

    WinGroup -> Login -> User -> DBRole

    So if you want people from WinGroup1 to be the same DBUser as WinGroup2, you have to put all Members into one Windows Group altogether and start from there.

    Makes sense?

    Andreas

    ---------------------------------------------------
    MVP SQL Server
    Microsoft Certified Master SQL Server 2008
    Microsoft Certified Solutions Master Data Platform, SQL Server 2012
    www.insidesql.org/blogs/andreaswolter
    www.andreas-wolter.com