Home Forums SQL Server 7,2000 Security How to determine SQL Security Login group for windows login when user is member of active directory security group. RE: How to determine SQL Security Login group for windows login when user is member of active directory security group.

  • May 24, 2007 at 3:04 am

    #708564

    If the user is a member of a DOMAIN\SecurityGroup that has Sysadmin authority in SQL, then that will be used when accessing databases.  Otherwise you need to look at what DOMAIN\SecurityGroup(s) have ben given authority in each database.  If the user is a member of 2 SecurityGroups, with SecGroupA having select authority and SecGroupB having insert authority, then the user can select and insert.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara