sp_helprole (Transact-SQL)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Returns information about the roles in the current database.
Transact-SQL syntax conventions
Syntax
sp_helprole [ [ @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, information about all roles in the current database is returned.
Return Code Values
0 (success) or 1 (failure)
Result Sets
Column name | Data type | Description |
---|---|---|
RoleName | sysname | Name of the role in the current database. |
RoleId | smallint | ID of RoleName. |
IsAppRole | int | 0 = RoleName is not an application role. 1 = RoleName is an application role. |
Remarks
To view the permissions associated with the role, use sp_helprotect. To view the members of a database role, use sp_helprolemember.
Permissions
Requires membership in the public role.
Examples
The following query returns all the roles in the current database.
EXEC sp_helprole
See Also
Security Stored Procedures (Transact-SQL)
Server-Level Roles
Database-Level Roles
sp_addapprole (Transact-SQL)
sp_addrole (Transact-SQL)
sp_droprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
sp_helpsrvrolemember (Transact-SQL)
System Stored Procedures (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