Printed 2017/07/22 03:21PM

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

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.