sys.dm_server_external_policy_role_members (Transact-SQL)
Applies to: SQL Server 2022 (16.x) Azure SQL Database
Lists all database and server principals created from Microsoft Entra ID (formerly Azure Active Directory) assigned to a given role on a given resource scope.
Column name | Data type | Description |
---|---|---|
principal_aad_object_id | int | Microsoft Entra Object ID of the principal. Is unique within an Azure tenant. |
role_guid | nvarchar(36) | The role name as defined in external policy source. |
action_type | nvarchar(128) | The type of an operation: Connect, Select. |
policy_guid | nvarchar(128) | Unique identifier of the policy that defines this assignment. |
assignment_scope | nvarchar(4000) | The hierarchical representation of the resource(s) that this assignment applies to. |
assignment_type | int | Type of the assignment: 1, 2 |
assignment_type_desc | nvarchar(5) | Type of the assignment description: Allow, Deny |
Permissions
Principals must have the VIEW SERVER SECURITY STATE permission.
See also
sys.dm_server_external_policy_principal_assigned_actions (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें