Skip to main content

mongo_user_definitions

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

Overview

Namemongo_user_definitions
TypeResource
Idazure.cosmos_db.mongo_user_definitions

Fields

The following fields are returned by SELECT queries:

The User Definition was successfully retrieved.

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

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectmongoUserDefinitionId, subscriptionId, resourceGroupName, accountNameRetrieves the properties of an existing Azure Cosmos DB Mongo User Definition with the given Id.
listselectsubscriptionId, resourceGroupName, accountNameRetrieves the list of all Azure Cosmos DB Mongo User Definition.
create_updateinsertmongoUserDefinitionId, subscriptionId, resourceGroupName, accountNameCreates or updates an Azure Cosmos DB Mongo User Definition.
deletedeletemongoUserDefinitionId, subscriptionId, resourceGroupName, accountNameDeletes an existing Azure Cosmos DB Mongo User 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.
mongoUserDefinitionIdstringThe ID for the User Definition {dbName.userName}.
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 User Definition with the given Id.

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

INSERT examples

Creates or updates an Azure Cosmos DB Mongo User Definition.

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

DELETE examples

Deletes an existing Azure Cosmos DB Mongo User Definition.

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