Skip to main content

access_policy

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

Overview

Nameaccess_policy
TypeResource
Idazure.redis.access_policy

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.
permissionsstringPermissions for the access policy. Learn how to configure permissions at https://aka.ms/redis/AADPreRequisites _. Required.
provisioningStatestringProvisioning state of access policy. Known values are: "Updating", "Succeeded", "Deleting", "Deleted", "Canceled", and "Failed". (Updating, Succeeded, Deleting, Deleted, Canceled, Failed)
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, cache_name, access_policy_name, subscription_idGets the detailed information about an access policy of a redis cache.
listselectresource_group_name, cache_name, subscription_idGets the list of access policies associated with this redis cache.
create_updateinsertresource_group_name, cache_name, access_policy_name, subscription_idAdds an access policy to the redis cache.
create_updatereplaceresource_group_name, cache_name, access_policy_name, subscription_idAdds an access policy to the redis cache.
deletedeleteresource_group_name, cache_name, access_policy_name, subscription_idDeletes the access policy from a redis cache.

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_namestringThe name of the access policy that is being added to the Redis cache. Required.
cache_namestringThe name of the Redis cache. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets the detailed information about an access policy of a redis cache.

SELECT
id,
name,
permissions,
provisioningState,
systemData,
type
FROM azure.redis.access_policy
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND cache_name = '{{ cache_name }}' -- required
AND access_policy_name = '{{ access_policy_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Adds an access policy to the redis cache.

INSERT INTO azure.redis.access_policy (
properties,
resource_group_name,
cache_name,
access_policy_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ cache_name }}',
'{{ access_policy_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Adds an access policy to the redis cache.

REPLACE azure.redis.access_policy
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND cache_name = '{{ cache_name }}' --required
AND access_policy_name = '{{ access_policy_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes the access policy from a redis cache.

DELETE FROM azure.redis.access_policy
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND cache_name = '{{ cache_name }}' --required
AND access_policy_name = '{{ access_policy_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;