sys.dm_server_external_policy_roles (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
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)