Skip to Content

Overview

QueryPie provides group functionality that allows you to bundle users into groups for collective management. Groups can be used as units for granting DB access permissions, Workflow approval/reviewer roles, and server or Kubernetes role assignments. The Groups page allows you to view and manage user group lists registered in QueryPie.

Viewing Group List

Navigate to the Administrator > General > User Management > Groups page to view the group list. You can search by group name. The following information is available for viewing:

Administrator > General > User Management > Groups

Administrator > General > User Management > Groups

  • Auth Provider: User authentication provider
    • Displays QueryPie or IdP Type configured in User Management > Authentication.
    • Manually registered groups are displayed as QueryPie.
    • Groups integrated from IdP are displayed with their respective ID Provider names.
  • Group Name: Group name
  • Members: List of users belonging to the group
  • Updated At: Date and time when group information was last changed
  • Created At: Group creation date and time

Manually Adding Groups

Clicking the Create Group button in the top right of the Groups page displays a modal. Enter the desired name and click the Save button to complete group creation.

Adding or removing users is only possible for manually added groups.
Groups synchronized from IdP only support viewing, and user list and group management must be performed in the IdP.

Adding Users to Groups

Clicking on a group in the list where you want to add users opens a Drawer where you can check detailed information.

Administrator > General > User Management > Groups > Details

Administrator > General > User Management > Groups > Details

  1. Clicking the + Add Users button displays a modal.
    1. You can search users by name or email.
    2. From version 11.2.0, deactivated users synchronized through LDAP are also included and displayed in search results. Inactive users show (Inactive) text next to their names.
    3. Clicking on a user you want to add changes their status to added.
    4. Clicking the Check all button at the bottom selects all users.
  2. Click the Save button to save group change history. You can check added users in the group list and details Drawer.

Q. I want to add a specific user to a group but they don’t appear in the modal. A. The user addition modal only displays users with active status. Check if the user’s account status is Inactive on the Users page.

Removing Users from Groups

  1. In the group details page, select users you want to remove using checkboxes, then click the Delete button displayed in the table header.
  2. Click the OK button in the user removal confirmation modal.
  3. Once user removal is complete, you can verify it in the user list within the Drawer and the Group list.

Administrator > General > User Management > Groups > Details

Administrator > General > User Management > Groups > Details

Changing Group Name

Clicking the Edit button at the top of the group details Drawer displays an edit modal. Change the group name and click the Save button to save.

Administrator > General > User Management > Groups > Details > Update Group

Administrator > General > User Management > Groups > Details > Update Group

Deleting Groups

Select groups you want to delete using checkboxes in the Groups list. The Delete button will appear in the table header. Click the button and click the OK button in the confirmation modal to complete deletion.

screenshot-20240726-123314.png

Group name change and deletion are only possible for groups manually added in QueryPie.

When a group is deleted, users belonging to the group are not deleted, but permissions and roles granted through the group are immediately revoked. Group deletion cannot be undone, so please exercise caution when executing.

Last updated on