Transact-SQL Reference
sp_helprolemember
Returns information about the members of a role in the current database.
Syntax
sp_helprolemember [ [ @rolename = ] 'role' ]
Arguments
[@rolename =] 'role'
Is the name of a role in the current database. role is sysname, with a default of NULL. role must exist in the current database. If role is not specified, then all roles that contain at least one member from the current database are returned.
Return Code Values
0 (success) or 1 (failure)
Result Sets
| Column name | Data type | Description |
|---|---|---|
| DbRole | sysname | Name of the role in the current database. |
| MemberName | sysname | Name of a member of DbRole. |
| MemberSID | varbinary(85) | Security identifier of MemberName. |
Remarks
If a subrole is a member of the specified role, use sp_helprolemember with the name of the subrole to see the members of the subrole.
Use sp_helpsrvrolemember to display the members of a fixed server role.
Permissions
Execute permissions default to the public role.
Examples
This example displays the members of the Sales role.
EXEC sp_helprolemember 'Sales'