sp_helprolemember (T-SQL)

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_helpsrvrolemember
sp_droprolemember System Stored Procedures
sp_helprole  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.