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%';
'[ Programing ] > Database' 카테고리의 다른 글
[MSSQL] ERROR 15023 (0) | 2021.03.30 |
---|---|
MS-SQL 사용자 계정 조회. (0) | 2021.03.30 |
MS-SQL BackUp Script (0) | 2021.03.26 |
MS-SQL 스크립트 생성. 데이터 & 스키마 추출 (0) | 2021.01.15 |
MS-SQL Group by 와 Distinct 성능 차이 (0) | 2021.01.15 |