access_control_records

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

Overview

Name	access_control_records
Type	Resource
Id	azure_extras.storsimple_1200_series.access_control_records

Fields

vw_access_control_records

Name	Datatype	Description
id	text	The identifier.
name	text	The name.
accessControlRecordName	text	field from the properties object
initiator_name	text	field from the properties object
managerName	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The type.

access_control_records

Name	Datatype	Description
id	string	The identifier.
name	string	The name.
properties	object	Properties of access control record
type	string	The type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accessControlRecordName, managerName, resourceGroupName, subscriptionId	Returns the properties of the specified access control record name.
list_by_manager	SELECT	managerName, resourceGroupName, subscriptionId	Retrieves all the access control records in a manager.
create_or_update	INSERT	accessControlRecordName, managerName, resourceGroupName, subscriptionId, data__properties	Creates or Updates an access control record.
delete	DELETE	accessControlRecordName, managerName, resourceGroupName, subscriptionId	Deletes the access control record.

SELECT examples

Retrieves all the access control records in a manager.

vw_access_control_records

SELECT
id,
name,
accessControlRecordName,
initiator_name,
managerName,
resourceGroupName,
subscriptionId,
type
FROM azure_extras.storsimple_1200_series.vw_access_control_records
WHERE managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

access_control_records

SELECT
id,
name,
properties,
type
FROM azure_extras.storsimple_1200_series.access_control_records
WHERE managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.storsimple_1200_series.access_control_records (
accessControlRecordName,
managerName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ accessControlRecordName }}',
'{{ managerName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: properties
      value:
        - name: initiatorName
          value: string

DELETE example

Deletes the specified access_control_records resource.

/*+ delete */
DELETE FROM azure_extras.storsimple_1200_series.access_control_records
WHERE accessControlRecordName = '{{ accessControlRecordName }}'
AND managerName = '{{ managerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';