[ 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%';