Skip to main content

access_policy_assignment

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

Overview

Nameaccess_policy_assignment
TypeResource
Idazure_isv.redisenterprise.access_policy_assignment

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
accessPolicyNamestringName of access policy under specific access policy assignment. Only "default" policy is supported for now. Required.
provisioningStatestringCurrent provisioning status of the access policy assignment. Known values are: "Succeeded", "Failed", "Canceled", "Creating", "Updating", and "Deleting". (Succeeded, Failed, Canceled, Creating, Updating, Deleting)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
userobjectThe user associated with the access policy. Required.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, cluster_name, database_name, access_policy_assignment_name, subscription_idGets information about access policy assignment for database.
listselectresource_group_name, cluster_name, database_name, subscription_idGets all access policy assignments..
create_updateinsertresource_group_name, cluster_name, database_name, access_policy_assignment_name, subscription_idCreates/Updates a particular access policy assignment for a database.
deletedeleteresource_group_name, cluster_name, database_name, access_policy_assignment_name, subscription_idDeletes 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
access_policy_assignment_namestringThe name of the Redis Enterprise database access policy assignment. Required.
cluster_namestringThe name of the Redis Enterprise cluster. Name must be 1-60 characters long. Allowed characters(A-Z, a-z, 0-9) and hyphen(-). There can be no leading nor trailing nor consecutive hyphens. Required.
database_namestringThe name of the Redis Enterprise database. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets information about access policy assignment for database.

SELECT
id,
name,
accessPolicyName,
provisioningState,
systemData,
type,
user
FROM azure_isv.redisenterprise.access_policy_assignment
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND cluster_name = '{{ cluster_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND access_policy_assignment_name = '{{ access_policy_assignment_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates/Updates a particular access policy assignment for a database.

INSERT INTO azure_isv.redisenterprise.access_policy_assignment (
properties,
resource_group_name,
cluster_name,
database_name,
access_policy_assignment_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ cluster_name }}',
'{{ database_name }}',
'{{ access_policy_assignment_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Deletes a single access policy assignment.

DELETE FROM azure_isv.redisenterprise.access_policy_assignment
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND cluster_name = '{{ cluster_name }}' --required
AND database_name = '{{ database_name }}' --required
AND access_policy_assignment_name = '{{ access_policy_assignment_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;