custom_entity_store_assignments

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

Overview

Name	custom_entity_store_assignments
Type	Resource
Id	azure.security.custom_entity_store_assignments

Fields

vw_custom_entity_store_assignments

Name	Datatype	Description
id	text	Resource Id
name	text	Resource name
customEntityStoreAssignmentName	text	field from the properties object
entity_store_database_link	text	field from the properties object
principal	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
type	text	Resource type

custom_entity_store_assignments

Name	Datatype	Description
id	string	Resource Id
name	string	Resource name
properties	object	describes the custom entity store assignment properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	customEntityStoreAssignmentName, resourceGroupName, subscriptionId	Gets a single custom entity store assignment by name for the provided subscription and resource group.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List custom entity store assignments by a provided subscription and resource group
list_by_subscription	SELECT	subscriptionId	List custom entity store assignments by provided subscription
create	INSERT	customEntityStoreAssignmentName, resourceGroupName, subscriptionId	Creates a custom entity store assignment for the provided subscription, if not already exists.
delete	DELETE	customEntityStoreAssignmentName, resourceGroupName, subscriptionId	Delete a custom entity store assignment by name for a provided subscription

SELECT examples

List custom entity store assignments by provided subscription

vw_custom_entity_store_assignments

SELECT
id,
name,
customEntityStoreAssignmentName,
entity_store_database_link,
principal,
resourceGroupName,
subscriptionId,
system_data,
type
FROM azure.security.vw_custom_entity_store_assignments
WHERE subscriptionId = '{{ subscriptionId }}';

custom_entity_store_assignments

SELECT
id,
name,
properties,
systemData,
type
FROM azure.security.custom_entity_store_assignments
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.security.custom_entity_store_assignments (
customEntityStoreAssignmentName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ customEntityStoreAssignmentName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: principal
          value: string

DELETE example

Deletes the specified custom_entity_store_assignments resource.

/*+ delete */
DELETE FROM azure.security.custom_entity_store_assignments
WHERE customEntityStoreAssignmentName = '{{ customEntityStoreAssignmentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';