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

DBRole		MemberName		MemberSID
My_Admin_Role	DOMAIN\muUser	0x010500000000000515000000313CF1C8B4034LF676BJA5EE7C0D0000

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


Leave a comment on the original post [, opens in a new window]

Loading comments...