Database Users and Roles

Feature

Users and Roles Setup in Germain

Viewing Users

  1. To view the list of users, navigate to System > Auth Settings > Users in the menu.

Setting Up Authentication

  1. Access System > Auth Settings > Authentication.

  2. Click "Add New Configuration."

  3. Select the JDBC Provider option and click "Next."

  4. Provide the following values:

    • Provider Name (The name of this provider).

    • Query for usernames (The query used for user authentication; leave as default for the default Germain database).

    • Query for authorities (The query used to assign user roles; leave as default for the default Germain database).

      Screenshot 2022-12-15 at 10.42.07.png
  5. Click "Finish."

Creating a User

  1. Go to System > Auth Settings > Users.

  2. Click "Add New User."

  3. Provide the following values:

    • Email (used as the username for login).

    • Roles (add at least one of the configured roles, determining user permissions).

    • Teams (membership in teams, affecting dashboard access).

    • Send Welcome Email (check to send an invitation email with password setup instructions).

      Screenshot 2022-12-15 at 10.22.32.png

    If "Send Welcome Email" is checked, the user will receive an email with login information. If not, you can reset the user's password later by clicking on the user in the list and selecting "Reset Password," which will send an email for password reset.

    Screenshot 2022-12-15 at 10.28.18.png

Login

  1. Log in using the username and password fields on the Germain login page.


Service: Authentication

Feature Availability: 8.6.0 or later