Skip to main content

access_policy_assignments

Creates, updates, deletes, gets or lists an access_policy_assignments resource.

Overview

Nameaccess_policy_assignments
TypeResource
Idazure_isv.redis.access_policy_assignments

Fields

The following fields are returned by SELECT queries:

Response of get access policy assignments.

NameDatatypeDescription
propertiesobjectProperties of an access policy assignment

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, cacheName, accessPolicyAssignmentName, subscriptionIdGets the list of assignments for an access policy of a redis cache
listselectresourceGroupName, cacheName, subscriptionIdGets the list of access policy assignments associated with this redis cache
create_updateinsertresourceGroupName, cacheName, accessPolicyAssignmentName, subscriptionIdAdds the access policy assignment to the specified users
deletedeleteresourceGroupName, cacheName, accessPolicyAssignmentName, subscriptionIdDeletes the access policy assignment from a redis cache

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
accessPolicyAssignmentNamestringThe name of the access policy assignment.
cacheNamestringThe name of the Redis cache.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the list of assignments for an access policy of a redis cache

SELECT
properties
FROM azure_isv.redis.access_policy_assignments
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND cacheName = '{{ cacheName }}' -- required
AND accessPolicyAssignmentName = '{{ accessPolicyAssignmentName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Adds the access policy assignment to the specified users

INSERT INTO azure_isv.redis.access_policy_assignments (
data__properties,
resourceGroupName,
cacheName,
accessPolicyAssignmentName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ cacheName }}',
'{{ accessPolicyAssignmentName }}',
'{{ subscriptionId }}'
RETURNING
properties
;

DELETE examples

Deletes the access policy assignment from a redis cache

DELETE FROM azure_isv.redis.access_policy_assignments
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND cacheName = '{{ cacheName }}' --required
AND accessPolicyAssignmentName = '{{ accessPolicyAssignmentName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;