Tag: "sys_server_principals"
Which login has what server role permissions
Jan 31st
Below script will query sys.server_role_members / sys.server_principals to find out which logins have what server role access.
CodeSELECT 'ServerRole' = CASEWHEN rm.role_principal_id > 2 THEN SUSER_NAME(rm.role_principal_id) END,lgn.name AS… more »
