SQL Server£º²é¿´Êý¾Ý¿âÓû§È¨ÏÞ£¨SQL 2005£©

1. ²é¿´ SQL 2005 Óû§ËùÊôÊý¾Ý¿â½ÇÉ«
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
2. ²é¿´ SQL 2005 µÇ½ÕÊ»§ËùÊô·þÎñÆ÷½ÇÉ«
use master
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
3. ²é¿´ SQL 2005 Óû§±»¸³ÓèµÄȨÏÞ
use yourdb
go
exec sp_helprotect @username = 'user name'
go