Skip to main content

role_management_policy_assignments

Creates, updates, deletes, gets or lists a role_management_policy_assignments resource.

Overview

Namerole_management_policy_assignments
TypeResource
Idazure.authorization.role_management_policy_assignments

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
effectiveRulesarrayThe readonly computed rule applied to the policy.
policyAssignmentPropertiesobjectAdditional properties of scope, role definition and policy.
policyIdstringThe policy id role management policy assignment.
roleDefinitionIdstringThe role definition of management policy assignment.
scopestringThe role management policy scope.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectscope, role_management_policy_assignment_nameGet the specified role management policy assignment for a resource scope.
list_for_scopeselectscopeGets role management assignment policies for a resource scope.
createinsertscope, role_management_policy_assignment_nameCreate a role management policy assignment.
deletedeletescope, role_management_policy_assignment_nameDelete a role management policy assignment.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
role_management_policy_assignment_namestringThe name of format {guid_guid} the role management policy assignment to get. Required.
scopestringThe fully qualified Azure Resource manager identifier of the resource. Required.

SELECT examples

Get the specified role management policy assignment for a resource scope.

SELECT
id,
name,
effectiveRules,
policyAssignmentProperties,
policyId,
roleDefinitionId,
scope,
systemData,
type
FROM azure.authorization.role_management_policy_assignments
WHERE scope = '{{ scope }}' -- required
AND role_management_policy_assignment_name = '{{ role_management_policy_assignment_name }}' -- required
;

INSERT examples

Create a role management policy assignment.

INSERT INTO azure.authorization.role_management_policy_assignments (
properties,
scope,
role_management_policy_assignment_name
)
SELECT
'{{ properties }}',
'{{ scope }}',
'{{ role_management_policy_assignment_name }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete a role management policy assignment.

DELETE FROM azure.authorization.role_management_policy_assignments
WHERE scope = '{{ scope }}' --required
AND role_management_policy_assignment_name = '{{ role_management_policy_assignment_name }}' --required
;