Skip to main content

mongo_role_definitions

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

Overview

Namemongo_role_definitions
TypeResource
Idazure.cosmos_db.mongo_role_definitions

Fields

The following fields are returned by SELECT queries:

The Mongo Role Definition was successfully retrieved.

NameDatatypeDescription
idstringThe unique resource identifier of the database account.
namestringThe name of the database account.
propertiesobjectProperties related to the Mongo Role Definition.
typestringThe type of Azure resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectmongoRoleDefinitionId, subscriptionId, resourceGroupName, accountNameRetrieves the properties of an existing Azure Cosmos DB Mongo Role Definition with the given Id.
listselectsubscriptionId, resourceGroupName, accountNameRetrieves the list of all Azure Cosmos DB Mongo Role Definitions.
create_updateinsertmongoRoleDefinitionId, subscriptionId, resourceGroupName, accountNameCreates or updates an Azure Cosmos DB Mongo Role Definition.
deletedeletemongoRoleDefinitionId, subscriptionId, resourceGroupName, accountNameDeletes an existing Azure Cosmos DB Mongo Role Definition.

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
accountNamestringCosmos DB database account name.
mongoRoleDefinitionIdstringThe ID for the Role Definition {dbName.roleName}.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Retrieves the properties of an existing Azure Cosmos DB Mongo Role Definition with the given Id.

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

INSERT examples

Creates or updates an Azure Cosmos DB Mongo Role Definition.

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

DELETE examples

Deletes an existing Azure Cosmos DB Mongo Role Definition.

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