22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT B.name AS roles,C.name AS users
FROM sys.database_role_members A
INNER JOIN sys.database_principals B ON A.role_principal_id = B.principal_id
INNER JOIN sys.database_principals C ON A.member_principal_id = c.principal_id
--用户对应角色
SELECT Member = Users.name, Role = Roles.Name
FROM sysusers Users, sysusers Roles, sysmembers Members
WHERE Roles.uid = Members.groupuid
AND Roles.issqlrole = 1
AND Users.uid = Members.memberuid
SELECT * FROM sys.syslogins
SELECT * FROM sys.sysusers