title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_server_external_policy_role_actions (Transact-SQL) |
Reference documentation to explain sys.dm_server_external_policy_role_actions (Transact-SQL) dynamic management view. |
srdan-bozovic-msft |
srbozovi |
11/07/2022 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE sqlserver2022]
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. |
Principals must have the VIEW SERVER SECURITY STATE permission.
sys.dm_server_external_policy_principal_assigned_actions (Transact-SQL)