sp_helprolemember

Transact-SQL Reference

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'

See Also

sp_addrolemember

sp_droprolemember

sp_helprole

sp_helpsrvrolemember

System Stored Procedures