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_enterprise.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
clusterName	text	field from the properties object
databaseName	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
user	text	field from the properties object

access_policy_assignments

Name	Datatype	Description
properties	object	Properties of Redis Enterprise database access policy assignment.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accessPolicyAssignmentName, clusterName, databaseName, resourceGroupName, subscriptionId	Gets information about access policy assignment for database.
list	SELECT	clusterName, databaseName, resourceGroupName, subscriptionId	Gets all access policy assignments..
create_update	INSERT	accessPolicyAssignmentName, clusterName, databaseName, resourceGroupName, subscriptionId	Creates/Updates a particular access policy assignment for a database
delete	DELETE	accessPolicyAssignmentName, clusterName, databaseName, resourceGroupName, subscriptionId	Deletes a single access policy assignment.

SELECT examples

Gets all access policy assignments..

vw_access_policy_assignments

SELECT
accessPolicyAssignmentName,
access_policy_name,
clusterName,
databaseName,
provisioning_state,
resourceGroupName,
subscriptionId,
user
FROM azure_isv.redis_enterprise.vw_access_policy_assignments
WHERE clusterName = '{{ clusterName }}'
AND databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

access_policy_assignments

SELECT
properties
FROM azure_isv.redis_enterprise.access_policy_assignments
WHERE clusterName = '{{ clusterName }}'
AND databaseName = '{{ databaseName }}'
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_enterprise.access_policy_assignments (
accessPolicyAssignmentName,
clusterName,
databaseName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accessPolicyAssignmentName }}',
'{{ clusterName }}',
'{{ databaseName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: accessPolicyName
          value: string
        - name: user
          value:
            - name: objectId
              value: string

DELETE example

Deletes the specified access_policy_assignments resource.

/*+ delete */
DELETE FROM azure_isv.redis_enterprise.access_policy_assignments
WHERE accessPolicyAssignmentName = '{{ accessPolicyAssignmentName }}'
AND clusterName = '{{ clusterName }}'
AND databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';