Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

SQL Database roles and members

Q. How can I obtain the members of a role within a database?

A.  One method is to use sp_helprolemember

 

EXEC mydatabase.dbo.sp_helprolemember

--returns 
DBRole		MemberName		MemberSID
My_Admin_Role	DOMAIN\muUser	0x010500000000000515000000313CF1C8B4034LF676BJA5EE7C0D0000

For a comprehensive security audit on database roles – read Powershell sql server security audit

Comments

Leave a comment on the original post [www.sqlserver-dba.com, opens in a new window]

Loading comments...