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:

OK - Returns information about the role management policy.

NameDatatypeDescription
idstringThe role management policy Id.
namestringThe role management policy name.
propertiesobjectRole management policy properties.
typestringThe role management policy type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectscope, roleManagementPolicyAssignmentNameGet the specified role management policy assignment for a resource scope
list_for_scopeselectscopeGets role management assignment policies for a resource scope.
createinsertscope, roleManagementPolicyAssignmentNameCreate a role management policy assignment
deletedeletescope, roleManagementPolicyAssignmentNameDelete 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
roleManagementPolicyAssignmentNamestringThe name of format {guid_guid} the role management policy assignment to delete.
scopestringThe scope of the role management policy assignment to delete.

SELECT examples

Get the specified role management policy assignment for a resource scope

SELECT
id,
name,
properties,
type
FROM azure.authorization.role_management_policy_assignments
WHERE scope = '{{ scope }}' -- required
AND roleManagementPolicyAssignmentName = '{{ roleManagementPolicyAssignmentName }}' -- required
;

INSERT examples

Create a role management policy assignment

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

DELETE examples

Delete a role management policy assignment

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