If you’re just getting started with CosmosDB, you might not have come across users and permissions in a CosmosDB database. However, there are certain use cases where managing users and permissions are necessary. For example, if you’re wanting to be able to limit access to a particular resource (e.g. a collection, document, stored procedure) by user.
The most common usage scenario for users and permissions is if you’re implementing a Resource Token Broker type pattern, allowing client applications to directly access the CosmosDB database.
Side note: The CosmosDB implementation of users and permissions only provides authorization – it does not provide authentication. It would be up to your own implementation to manage the authentication. In most cases you’d use something like Azure Active Directory to provide an authentication layer.
But if you go hunting through the Azure Management Portal CosmosDB data explorer (or Azure Storage Explorer) you won’t find any way to configure or even view users and permissions.
But to make CosmosDB users and permissions easier to manage from PowerShell, I created the CosmosDB PowerShell module. This is an open source project hosted on GitHub. The CosmosDB module allows you to manage much more than just users and permissions, but for this post I just wanted to start with these.
This module works on PowerShell 5.x and PowerShell Core 6.0.0. It probably works on PowerShell 3 and 4, but I don’t have any more machines running this version to test on.
The CosmosDB module does not have any dependencies, except if you call the New-CosmosDbConnection function with the ResourceGroup parameter specified as this will use the AzureRM PowerShell modules to read the Master Key for the connection directly from your CosmosDB account. So I’d recommend installing the Azure PowerShell modules or if you’re using PowerShell 6.0, install the AzureRM.NetCore modules.
Installing the Module
install-module -Name CosmosDB -Scope CurrentUser
Or to install it for all users on the machine (requires administrator permissions):
install-module -Name CosmosDB
Before you get down to the process of working with CosmosDB resources, you’ll need to configure the information required to connect. This requires the following information:
- The CosmosDB Account name
- The CosmosDB Database name
- The Master Key for the account (you can have the CosmosDB PowerShell module get this directly from your Azure account if you wish).
To create the connection variable we just use the New-CosmosDbConnection:
If you do not wish to specify your master key, you can have the New-CosmosDbConnection function pull your master key from the Azure Management Portal directly:
Note: This requires the AzureRM.Profile and AzureRM.Resoures module on Windows PowerShell 5.x or AzureRM.Profile.NetCore and AzureRM.Resources.NetCore on PoweShell Core 6.0.0.
To add a user to the CosmosDB Database use the New-CosmosDBUser function:
New-CosmosDbUser -Connection $connection -Id 'daniel'
To get a list of users in the database:
Get-CosmosDbUser -Connection $connection
To get a specific user:
Get-CosmosDbUser -Connection $connection -Id 'daniel'
To remove a user (this will also remove all permissions assigned to the user):
Remove-CosmosDbUser -Connection $connection -Id 'daniel'
Permissions in CosmosDB are granted to a user for a specific resource. For example, you could grant a user access to just a single document, an entire collection or to a stored procedure.
To grant a permission you need to provide four pieces of information:
- The Id of the user to grant the permission to.
- An Id for the permission to create. This is just string to uniquely identify the permission.
- The permission mode to the permission: All or Read.
- The Id of the resource to grant access to. This can be generated from one of the Get-CosmosDb*ResourcePath functions in the CosmosDB PowerShell module.
In the following example, we’ll grant the user daniel all access to the TestCollection:
Once a permission has been granted, you can use the Get-CosmosDbPermission function to retrieve the permission and with it the Resource Token that can be used to access the resource for a limited amount of time (between 10 minutes and 5 hours).
Note: as you have the Master Key already, using the Resource Token isn’t required.
For example, to retrieve all permissions for the user with Id daniel and a resource token expiration of 600 seconds:
Get-CosmosDbPermission -Connection $connection -UserId 'daniel' -TokenExpiry '600' | fl *
You can as expected delete a permission by using the Remove-CosmosDbPermission function:
Remove-CosmosDbPermission -Connection $connection -UserId 'daniel' -Id 'AccessTestCollection'
So this is pretty much all there is to managing users and permissions using the CosmosDB PowerShell module. This module can also be used to manage the following CosmosDB resources:
- Stored procedures
- User Defined Functions
You can find additional documentation and examples of how to manage these resources over in the CosmosDB PowerShell module readme file on GitHub.
Hopefully this will help you in any CosmosDB automation tasks you might need to implement.