sys.dm_server_external_policy_actions (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database

List all available data actions, independently of them being used or not.

Column name Data type Description
sql_action_id int Internal ID for joining with other dynamic management views. Not used by external policy providers.
action_namespace nvarchar(256) The path or namespace on which the action type part applies to.
action_type varchar(20) Identifies the type of operation.
action_provider_string varchar(20) Identifies the resource provider that owns the action. Currently only supported value is Microsoft.Sql.

Permissions

Principals must have the VIEW SERVER SECURITY STATE permission.

Next steps