[ Programing ]/Database

MS-SQL 로그인 계정 조회

Mister_Q 2021. 3. 30. 09:28

SELECT _role.Name, _role.Type_Desc, _member.Name MemberName, _member.Type_Desc
FROM sys.server_role_members AS _roleMember
     INNER JOIN sys.server_principals AS _role
           ON _role.Principal_Id = _roleMember.Role_Principal_Id

     INNER JOIN sys.server_principals AS _member
           ON _member.Principal_Id = _roleMember.Member_Principal_Id

WHERE _member.name NOT LIKE '%system%' 
      AND _member.name NOT LIKE '%SQLServer%';