access_policy_assignments

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

Overview

Name	access_policy_assignments
Type	Resource
Id	azure_isv.redis.access_policy_assignments

Fields

vw_access_policy_assignments

Name	Datatype	Description
accessPolicyAssignmentName	text	field from the properties object
access_policy_name	text	field from the properties object
cacheName	text	field from the properties object
object_id	text	field from the properties object
object_id_alias	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object

access_policy_assignments

Name	Datatype	Description
properties	object	Properties for an access policy assignment

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accessPolicyAssignmentName, cacheName, resourceGroupName, subscriptionId	Gets the list of assignments for an access policy of a redis cache
list	SELECT	cacheName, resourceGroupName, subscriptionId	Gets the list of access policy assignments associated with this redis cache
create_update	INSERT	accessPolicyAssignmentName, cacheName, resourceGroupName, subscriptionId	Adds the access policy assignment to the specified users
delete	DELETE	accessPolicyAssignmentName, cacheName, resourceGroupName, subscriptionId	Deletes the access policy assignment from a redis cache

SELECT examples

Gets the list of access policy assignments associated with this redis cache

vw_access_policy_assignments

SELECT
accessPolicyAssignmentName,
access_policy_name,
cacheName,
object_id,
object_id_alias,
provisioning_state,
resourceGroupName,
subscriptionId
FROM azure_isv.redis.vw_access_policy_assignments
WHERE cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

access_policy_assignments

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

INSERT example

Use the following StackQL query and manifest file to create a new access_policy_assignments resource.

All Properties

/*+ create */
INSERT INTO azure_isv.redis.access_policy_assignments (
accessPolicyAssignmentName,
cacheName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accessPolicyAssignmentName }}',
'{{ cacheName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: objectId
          value: string
        - name: objectIdAlias
          value: string
        - name: accessPolicyName
          value: string

DELETE example

Deletes the specified access_policy_assignments resource.

/*+ delete */
DELETE FROM azure_isv.redis.access_policy_assignments
WHERE accessPolicyAssignmentName = '{{ accessPolicyAssignmentName }}'
AND cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';