Skip to main content

access_policy_assignments

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

Overview

Nameaccess_policy_assignments
TypeResource
Idazure_isv.redis_enterprise.access_policy_assignments

Fields

NameDatatypeDescription
accessPolicyAssignmentNametextfield from the properties object
access_policy_nametextfield from the properties object
clusterNametextfield from the properties object
databaseNametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
subscriptionIdtextfield from the properties object
usertextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTaccessPolicyAssignmentName, clusterName, databaseName, resourceGroupName, subscriptionIdGets information about access policy assignment for database.
listSELECTclusterName, databaseName, resourceGroupName, subscriptionIdGets all access policy assignments..
create_updateINSERTaccessPolicyAssignmentName, clusterName, databaseName, resourceGroupName, subscriptionIdCreates/Updates a particular access policy assignment for a database
deleteDELETEaccessPolicyAssignmentName, clusterName, databaseName, resourceGroupName, subscriptionIdDeletes a single access policy assignment.

SELECT examples

Gets all 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 }}';

INSERT example

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

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

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 }}';