Windows Authentication - Multiple Groups

If a user is a member of more than one Windows groups, what permissions will
the user be granted upon logging into SQL Server if the different groups
have different access rights?

Michael MacGregor
Database Architect


.

Relevant Pages

  • Re: Roles - Users
    ... Developer is a domain level group. ... association with the legacy domain permissions on the server. ... Windows groups he is a member of. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication
    ... I'm wondering what the best way to set up security on SQL Server 2000 ... (would end up with quite a few different Windows Groups). ... permissions the user has. ...
    (microsoft.public.sqlserver.security)
  • getting a list of groups a specific user belongs to in sql server 2000
    ... determine which Windows groups a user belongs to if logging into the ... permissions of a user, but since most permissions are granted through ...
    (microsoft.public.sqlserver.security)
  • Re: How to implement Windows Authentication?
    ... some login has to be created outside the application. ... in windows can access SQL Server as sysadmin. ... If adding windows groups to SQL ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: getting a list of groups a specific user belongs to in sql server 2000
    ... where login permissions were dictated by the users ... > The mapped login name should provide you with the groups being used by ... To know what database roles a user is part of, ... >>> determine which Windows groups a user belongs to if logging into the ...
    (microsoft.public.sqlserver.security)