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 = ] 'role' ]
Arguments
[ @srvrolename = ] 'role'
Is the name of a fixed server role. role is sysname, with a default of NULL. If roleis not specified, the result set includes information about all fixed server roles.
role 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 |
Return Code Values
0 (success) or 1 (failure)
Result Sets
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 does not recognize the public role because, internally, SQL Server does not implement public as a role.
To add or removed members from server roles, see ALTER SERVER ROLE (Transact-SQL).
sp_helpsrvrolemember does not 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 (Transact-SQL).
Permissions
Requires membership in the public role.
Examples
The following example lists the members of the sysadmin
fixed server role.
EXEC sp_helpsrvrolemember 'sysadmin';
See Also
sp_helprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)
Security Functions (Transact-SQL)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho