sql_role_assignments

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

Overview

Name	sql_role_assignments
Type	Resource
Id	azure.cosmos_db.sql_role_assignments

Fields

The following fields are returned by SELECT queries:

get

The Role Assignment was successfully retrieved.

Name	Datatype	Description
id	string	The unique resource identifier of the database account.
name	string	The name of the database account.
properties	object	Properties related to the Role Assignment.
type	string	The type of Azure resource.

list

The list operation completed successfully.

Name	Datatype	Description
id	string	The unique resource identifier of the database account.
name	string	The name of the database account.
properties	object	Properties related to the Role Assignment.
type	string	The type of Azure resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	roleAssignmentId, subscriptionId, resourceGroupName, accountName		Retrieves the properties of an existing Azure Cosmos DB SQL Role Assignment with the given Id.
list	select	subscriptionId, resourceGroupName, accountName		Retrieves the list of all Azure Cosmos DB SQL Role Assignments.
create_update	insert	roleAssignmentId, subscriptionId, resourceGroupName, accountName		Creates or updates an Azure Cosmos DB SQL Role Assignment.
delete	delete	roleAssignmentId, subscriptionId, resourceGroupName, accountName		Deletes an existing Azure Cosmos DB SQL Role 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.

Name	Datatype	Description
accountName	string	Cosmos DB database account name.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
roleAssignmentId	string	The GUID for the Role Assignment.
subscriptionId	string	The ID of the target subscription.

SELECT examples

get

Retrieves the properties of an existing Azure Cosmos DB SQL Role Assignment with the given Id.

SELECT
id,
name,
properties,
type
FROM azure.cosmos_db.sql_role_assignments
WHERE roleAssignmentId = '{{ roleAssignmentId }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
;

list

Retrieves the list of all Azure Cosmos DB SQL Role Assignments.

SELECT
id,
name,
properties,
type
FROM azure.cosmos_db.sql_role_assignments
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
;

INSERT examples

create_update

Creates or updates an Azure Cosmos DB SQL Role Assignment.

INSERT INTO azure.cosmos_db.sql_role_assignments (
data__properties,
roleAssignmentId,
subscriptionId,
resourceGroupName,
accountName
)
SELECT 
'{{ properties }}',
'{{ roleAssignmentId }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}'
RETURNING
id,
name,
properties,
type
;

Manifest

# Description fields are for documentation purposes
- name: sql_role_assignments
  props:
    - name: roleAssignmentId
      value: string
      description: Required parameter for the sql_role_assignments resource.
    - name: subscriptionId
      value: string
      description: Required parameter for the sql_role_assignments resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the sql_role_assignments resource.
    - name: accountName
      value: string
      description: Required parameter for the sql_role_assignments resource.
    - name: properties
      value: object
      description: |
        Properties to create and update an Azure Cosmos DB SQL Role Assignment.

DELETE examples

delete

Deletes an existing Azure Cosmos DB SQL Role Assignment.

DELETE FROM azure.cosmos_db.sql_role_assignments
WHERE roleAssignmentId = '{{ roleAssignmentId }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
;