SQL Server 2005查看数据库用户权限
- 作者: 如果不爱-请你走开-别让我痴痴的等待
- 来源: 51数据库
- 2022-08-17
use yourdb 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
推荐阅读
