SQL Server Performance

if a user is a member of multiple sql login AD groups ...

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Aug 15, 2013.

  1. Trev256b Member

    if a user is a member of multiple sql login AD groups does the user have all the permissions of all SQL logins or just one SQL login?

    and if just one login, which one?
  2. ghemant Moderator

    Hi,

    My understanding says *it depends* on what kind of permission that AD group has on the server/database. i.e. Login1 is member of DBA and DEV on Server1 and Server2 respectively, and,

    Server1: AD Group Dev has db_datareader and db_datareader permission, then user Login1 will have that only permissions
    Server2: AD Group DBA has SA access or DBO for few databases , Login1 will have that many permissions

    hth

Share This Page