Redigera

Dela via


sp_helpsrvrolemember (Transact-SQL)

Applies to: SQL Server

Returns information about the members of a SQL Server fixed server role.

Transact-SQL syntax conventions

Syntax

sp_helpsrvrolemember [ [ @srvrolename = ] N'srvrolename' ]
[ ; ]

Arguments

[ @srvrolename = ] N'srvrolename'

The name of a fixed server role. @srvrolename is sysname, with a default of NULL, and can be any of the following values.

Fixed server role Description
sysadmin System administrators
securityadmin Security administrators
serveradmin Server administrators
setupadmin Setup administrators
processadmin Process administrators
diskadmin Disk administrators
dbcreator Database creators
bulkadmin Can execute BULK INSERT statements

If @srvrolename isn't specified, the result set includes information about all fixed server roles.

Return code values

0 (success) or 1 (failure).

Result set

Column name Data type Description
ServerRole sysname Name of the server role
MemberName sysname Name of a member of ServerRole
MemberSID varbinary(85) Security identifier of MemberName

Remarks

Use sp_helprolemember to display the members of a database role.

All logins are a member of public. sp_helpsrvrolemember doesn't recognize the public role because, internally, SQL Server doesn't implement public as a role.

To add or removed members from server roles, see ALTER SERVER ROLE.

sp_helpsrvrolemember doesn't take a user-defined server role as an argument. To determine the members of a user-defined server role, see the examples in ALTER SERVER ROLE.

Permissions

Requires membership in the public role.

Examples

The following example lists the members of the sysadmin fixed server role.

EXEC sp_helpsrvrolemember 'sysadmin';