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

# Database Users and Roles

> GermainUX can authenticate Workspace users against a database through a JDBC authentication provider.

Service
`Authentication`

Availability
8.6.0 or later

GermainUX can authenticate Workspace users against a database through a JDBC authentication provider.

This approach allows administrators to:

* Create and manage users from the Germain Workspace
* Use an email address as the login username
* Assign permissions through Roles
* Control dashboard and data visibility through Teams
* Send welcome and password-reset emails

> [!NOTE]
>
> **Note:** This page describes GermainUX Workspace accounts authenticated through a database. It does not cover database-administrator accounts.

> [card] [View Users](#view-users)
>
> See workspace accounts

> [card] [Create a User](#create-a-user)
>
> Add new accounts

> [card] [Welcome Email and Password Setup](#welcome-email-and-password-setup)
>
> Resend setup instructions

> [card] [Log In](#log-in)
>
> Sign in options

## View Users

Go to:

**Germain Workspace > Left Menu > System > Auth Settings > Users**

The **Users** page displays the accounts currently configured for the Germain Workspace.

## Configure JDBC Authentication

**1. Go to System > Auth Settings > Authentication**

**2. Click Add New Configuration**

**3. Select JDBC Provider**

**4. Click Next**

**5. Configure the provider fields**

**6. Click Finish**

| Field | Description |
| - | - |
| **Provider Name** | Unique name used to identify the JDBC authentication provider. |
| **Query for Usernames** | Query used to retrieve and authenticate users. Keep the default value when using the standard GermainUX database schema. |
| **Query for Authorities** | Query used to retrieve the Roles or authorities assigned to each user. Keep the default value when using the standard GermainUX database schema.  ![Database Users and Roles: Configure JDBC Authentication](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/database-user-management/Screenshot-2022-12-15-at-10.42.07.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=95dac621e0ba497f68aef3f9f8bfa26a) |

## Create a User

**1. Go to System > Auth Settings > Users**

**2. Click Add New User**

**3. Configure the user fields**

**4. Save the account**

| Field | Description |
| - | - |
| **Email** | User’s email address. It is also used as the login username. |
| **Roles** | Determines which operations the user can perform. Assign at least one configured Role. |
| **Teams** | Determines the user’s dashboard, data, and Session Replay visibility. |
| **Send Welcome Email** | Sends the user an invitation containing password-setup instructions.  ![Database Users and Roles: Create a User](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/database-user-management/Screenshot-2022-12-15-at-10.22.32.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=fa2e67df8012df1c43647ac3ddb4116b) |

## Welcome Email and Password Setup

When **Send Welcome Email** is enabled, GermainUX sends the new user instructions for creating a password.

If the welcome email was not sent when the account was created:

1. Go to **System > Auth Settings > Users**.
2. Select the user.
3. Click **Reset Password**.

   ![Database Users and Roles: Welcome Email and Password Setup](https://mintcdn.com/germain-ux/hPK2RwO7wyn44bNw/images/main/database-user-management/Screenshot-2022-12-15-at-10.28.18.png?fit=max\&auto=format\&n=hPK2RwO7wyn44bNw\&q=85\&s=35aae7e66dd65360bf73f31043373640)
4. GermainUX sends the user a password-reset email.

## Edit or Remove a User

From **System > Auth Settings > Users**, select an existing user to:

* Update assigned Roles
* Update Team memberships
* Reset the password
* Enable or disable access
* Remove the account

Changes to Roles or Teams affect the user’s permissions and visibility within the Germain Workspace.

## Log In

The user can log in from the GermainUX login page using:

| Field | Value |
| - | - |
| **Username** | Email address configured for the account |
| **Password** | Password created through the welcome or reset process  |

## Get Help

> [card] [Contact GermainUX Support](https://docs.germainux.com/main/support.md)
>
> The GermainUX team helps you get up and running faster, empower your team, turn data into actionable insights, and optimize performance to deliver measurable business outcomes.

> [card] Can't find what you need?
>
> Search all GermainUX docs with **Ctrl + K**, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.