sysadmin 계정 조회

?

1 2 3 4 5 6 7 8 9 10 11 12 13

select       spr.name,              spr.default_database_name,              spr.create_date, spr.modify_date,              suser_name(srm.role_principal_id) as server_role_name from sys.server_principals as spr with (nolock)        inner join sys.server_permissions as spm (nolock) on spm.grantee_principal_id = spr.principal_id     left join sys.server_role_members as srm with (nolocK) on spr.name = suser_name(srm.member_principal_id) where 1=1--spr.name not in ()     and spr.name not like '##%'     and spr.name not like 'NT %'     and suser_name(srm.role_principal_id) = 'sysadmin'             and spr.is_disabled = 0 order by spr.type,spr.name