Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Returns information about the direct members of a role in the current database.
Transact-SQL syntax conventions
Syntax
sp_helprolemember [ [ @rolename = ] N'rolename' ]
[ ; ]
Arguments
[ @rolename = ] N'rolename'
The name of a role in the current database. @rolename is sysname, with a default of NULL. @rolename must exist in the current database. If @rolename isn't 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 set
| 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 the database contains nested roles, MemberName might be the name of a role. sp_helprolemember doesn't show membership obtained through nested roles. For example if User1 is a member of Role1, and Role1 is a member of Role2, EXEC sp_helprolemember 'Role2'; returns Role1, but not the members of Role1 (User1 in this example). To return nested memberships, you must execute sp_helprolemember repeatedly for each nested role.
Use sp_helpsrvrolemember to display the members of a fixed server role.
Use IS_ROLEMEMBER to check role membership for a specified user.
Permissions
Requires membership in the public role.
Examples
The following example displays the members of the Sales role in the AdventureWorks2022 database.
EXEC sp_helprolemember 'Sales';