---
title: "Batch Assign User Permissions"
slug: "batch-assign-user-permissions-using-query"
updated: 2026-02-19T23:13:39Z
published: 2026-02-19T23:13:39Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Batch Assign User Permissions

Assigning permissions to multiple users after accounts have been created is quick and easy with the query tool.

## Creating and Running the Query

1. Click **Queries / Reports** in the top navigation bar and start a new **Quick Query**.
2. Set the **Type**to Configurable Joins.
3. Set the **Category** to Related.
4. Set the **Base**to User.
5. Click **Build Query**.
6. Add a filter for **Name** if you wish to choose multiple users to assign the new permission. Use CTRL-SHIFT or CTRL-Click to select different users from the list presented.

[![name_select.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/14229919602715.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/14229919602715.png)
7. Add **at least one export** such as User Full Name.
8. Click **Run Query**.
9. From the Query Results page, set the **Output type** to Security under the Batch Management section and click **Export**.
10. Within the pop-up window select one of the following permission-related actions:
  - **Assign Role** - Assigns the selected role to all users in the query results
  - **Remove Role** - Removes the selected role from all users in the query results.
  - **Add Explicit Permission** - Adds the selected permission to all users in the query results.
  - **Remove Explicit Permission** - Removed the selected permission from all users in the query results (this does not prevent the permission from being inherited from a role).
  - **Update User Status** - Activate all users in the query results or Inactivate all users in the query results.
  - **Set User Expiration Date** - Set an expiration date (upon this date the user will no longer have access to Slate) for all users in the query results. Leave the “Expires After” box blank to clear the Expiration Date from all users in the query results.
  - **Set User Multi-Factor Authentication** - Activates [multi-factor authentication](/v1/docs/multi-factor-authentication-mfa) for increased system security
11. Click **Submit******to update the selected users’ permissions.