Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
SQL database in Microsoft Fabric
List all available roles, independently of them being used or not. Not all roles listed may be applicable to SQL Server.
| Column name | Data type | Description |
|---|---|---|
| role_name | nvarchar(128) | ID for joining with other dynamic management views. |
| role_guid | nvarchar(128) | The role name as defined in external policy source. Has to be unique. |
| modify_date | datetime2 | Time when the role definition was changed. |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.
See also
sys.dm_server_external_policy_principal_assigned_actions (Transact-SQL)