sys.dm_server_external_policy_role_actions (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
Lists the links between the roles and actions and can be used to join the two DMVs sys.dm_server_external_policy_roles and sys.dm_server_external_policy_actions.
| Column name | Data type | Description |
|---|---|---|
| role_guid | nvarchar(128) | The role name as defined in external policy source. Has to be unique. |
| sql_action_id | int | Internal ID for joining with other dynamic management views. Not used by external policy providers. |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.
See also
sys.dm_server_external_policy_principal_assigned_actions (Transact-SQL)