SQL Server使用SQL语句查询角色/用户

查询用户角色：

select UserName = u.name,DbRole = g.name
from sys.database_principals u, sys.database_principals g, sys.database_role_members m 
where g.principal_id = m.role_principal_id 
and u.principal_id = m.member_principal_id 
order by 1, 2 
go

select DbRole = g.name, MemberName = u.name, MemberSID = u.sid 
from sys.database_principals u, sys.database_principals g, sys.database_role_members m 
where g.principal_id = m.role_principal_id 
and u.principal_id = m.member_principal_id 
order by 1, 2 
go

select SrvRole = g.name, MemberName = u.name, MemberSID = u.sid 
from sys.server_principals u, sys.server_principals g, sys.server_role_members m 
where g.principal_id = m.role_principal_id 
and u.principal_id = m.member_principal_id 
order by 1, 2 
go

看服务器角色：

select 用户名 = u.name,管理员权限 = g.name,是否在用 = u.is_disabled,MemberSID = u.sid 
from sys.server_principals u, sys.server_principals g, sys.server_role_members m 
where g.principal_id = m.role_principal_id 
and u.principal_id = m.member_principal_id 
and g.name = 'sysadmin'
order by 1, 2
go

版权声明：本文内容始发于CSDN>作者:sdm_seven，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。本作品采用知识共享署名-非商业性使用-禁止演绎 2.5 中国大陆许可协议进行许可。始发链接:https://blog.csdn.net/sdm_seven/article/details/125800410在此特别鸣谢原作者的创作。此篇文章的所有版权归原作者所有，商业转载建议请联系原作者，非商业转载请注明出处。