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_enterprise.access_policy_assignments

Fields

The following fields are returned by SELECT queries:

Successfully found the access policy assignment

NameDatatypeDescription
propertiesobjectProperties of the access policy assignment. (title: Redis Enterprise database access policy assignment properties)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, clusterName, databaseName, accessPolicyAssignmentNameGets information about access policy assignment for database.
listselectsubscriptionId, resourceGroupName, clusterName, databaseNameGets all access policy assignments..
create_updateinsertsubscriptionId, resourceGroupName, clusterName, databaseName, accessPolicyAssignmentNameCreates/Updates a particular access policy assignment for a database
deletedeletesubscriptionId, resourceGroupName, clusterName, databaseName, accessPolicyAssignmentNameDeletes a single access 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
accessPolicyAssignmentNamestringThe name of the Redis Enterprise database access policy assignment.
clusterNamestringThe name of the Redis Enterprise cluster.
databaseNamestringThe name of the Redis Enterprise database.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets information about access policy assignment for database.

SELECT
properties
FROM azure_isv.redis_enterprise.access_policy_assignments
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND clusterName = '{{ clusterName }}' -- required
AND databaseName = '{{ databaseName }}' -- required
AND accessPolicyAssignmentName = '{{ accessPolicyAssignmentName }}' -- required
;

INSERT examples

Creates/Updates a particular access policy assignment for a database

INSERT INTO azure_isv.redis_enterprise.access_policy_assignments (
data__properties,
subscriptionId,
resourceGroupName,
clusterName,
databaseName,
accessPolicyAssignmentName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ clusterName }}',
'{{ databaseName }}',
'{{ accessPolicyAssignmentName }}'
RETURNING
properties
;

DELETE examples

Deletes a single access policy assignment.

DELETE FROM azure_isv.redis_enterprise.access_policy_assignments
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND clusterName = '{{ clusterName }}' --required
AND databaseName = '{{ databaseName }}' --required
AND accessPolicyAssignmentName = '{{ accessPolicyAssignmentName }}' --required
;