sp_helpsrvrole (Transact-SQL)
Applies to: SQL Server
Returns a list of the SQL Server fixed server roles.
Transact-SQL syntax conventions
Syntax
sp_helpsrvrole [ [ @srvrolename = ] 'role' ]
Arguments
[ @srvrolename = ] 'role'
Is the name of the fixed server role. role is sysname, with a default of NULL. role can be one 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 |
Return Code Values
0 (success) or 1 (failure)
Result Sets
Column name | Data type | Description |
---|---|---|
ServerRole | sysname | Name of the server role |
Description | sysname | Description of ServerRole |
Remarks
Fixed server roles are defined at the server level and have permissions to perform specific server-level administrative activities. Fixed server roles cannot be added, removed, or changed.
To add or removed members from server roles, see ALTER SERVER ROLE (Transact-SQL).
All logins are a member of public. sp_helpsrvrole does not recognize the public role because, internally, SQL Server does not implement public as a role.
sp_helpsrvrole does not take a user-defined server role as an argument. To list the user-defined server roles, see the examples in ALTER SERVER ROLE (Transact-SQL).
Permissions
Requires membership in the public role.
Examples
A. Listing the fixed server roles
The following query returns the list of fixed server roles.
EXEC sp_helpsrvrole ;
B. Listing fixed and user-defined server roles
The following query returns a list of both fixed and user-defined server roles.
SELECT * FROM sys.server_principals WHERE type = 'R' ;
C. Returning a description of a fixed server role
The following query returns the name and description of the diskadmin
fixed server roles.
sp_helpsrvrole 'diskadmin' ;
See Also
Security Stored Procedures (Transact-SQL)
Server-Level Roles
sp_addsrvrolemember (Transact-SQL)
sp_dropsrvrolemember (Transact-SQL)
sp_helpsrvrolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for