Skip to main content

users

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

Overview

Nameusers
TypeResource
Idazure.mongo_cluster.users

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
identityProviderobjectThe user's identity provider definition.
provisioningStatestringThe provisioning state of the user. Known values are: "Succeeded", "Failed", "Canceled", "InProgress", "Updating", and "Dropping". (Succeeded, Failed, Canceled, InProgress, Updating, Dropping)
rolesarrayDatabase roles that are assigned to the user.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, mongo_cluster_name, user_name, subscription_idGets the defintion of a Mongo cluster user.
list_by_mongo_clusterselectresource_group_name, mongo_cluster_name, subscription_idList all the users on a mongo cluster.
create_or_updateinsertresource_group_name, mongo_cluster_name, user_name, subscription_idCreates a new user or updates an existing user on a mongo cluster.
create_or_updatereplaceresource_group_name, mongo_cluster_name, user_name, subscription_idCreates a new user or updates an existing user on a mongo cluster.
deletedeleteresource_group_name, mongo_cluster_name, user_name, subscription_idDeletes a mongo cluster user.

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
mongo_cluster_namestringThe name of the mongo cluster. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
user_namestringThe name of the mongo cluster user. Required.

SELECT examples

Gets the defintion of a Mongo cluster user.

SELECT
id,
name,
identityProvider,
provisioningState,
roles,
systemData,
type
FROM azure.mongo_cluster.users
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND mongo_cluster_name = '{{ mongo_cluster_name }}' -- required
AND user_name = '{{ user_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a new user or updates an existing user on a mongo cluster.

INSERT INTO azure.mongo_cluster.users (
properties,
resource_group_name,
mongo_cluster_name,
user_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ mongo_cluster_name }}',
'{{ user_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Creates a new user or updates an existing user on a mongo cluster.

REPLACE azure.mongo_cluster.users
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND mongo_cluster_name = '{{ mongo_cluster_name }}' --required
AND user_name = '{{ user_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Deletes a mongo cluster user.

DELETE FROM azure.mongo_cluster.users
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND mongo_cluster_name = '{{ mongo_cluster_name }}' --required
AND user_name = '{{ user_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;