Επεξεργασία

Κοινή χρήση μέσω


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)