Manage Users

This section explains how to manage users in an Exasol SaaS organization account.

The Users page in the web console provides an overview of the users in the account, including their contact information, roles, and the databases to which they have access. If you have the Owner role, you can invite new users and edit or remove users on this page.

Invite a new user

You must have the Owner role to invite users.

1. On the Users page, click on Invite user.

2. In the Organization role dialog, enter a valid email address for the user and select an organization role (Member or Owner), then click on Next.

   

3. In the DB Access dialog, enter a unique username for the invited user. A database user with this name will be created on each database that you specify in the next step.

   

4. Select the Public role on each database that the user should be able to access. Additional privileges must be granted using SQL (see below).

5. Click on Invite to close the dialog and send the invitation, or click on Back to go back to the Organization role step.

The user will receive an email with a link to accept the invitation and complete their profile.

Grant additional privileges

When you have created the invitation, you will be asked to grant additional privileges using an automatically generated worksheet that can be edited as needed. You can do this step immediately after sending the invite or at a later time as you wish. You can also delete the auto-generated worksheet and grant privileges in a new worksheet or using an SQL client.

Manage invitations

Invited users are listed under the Invitations tab until they have accepted the invitation and completed their profile.

You can copy the invitation URL, resend the invitation, or revoke the invitation using the dropdown menu for each pending invitation.

Edit users

You must have the Owner role to edit users.

As an account owner, you can change the web console role and database access for all users in the account.

1. On the Users page, click on ... on the user that you want to edit and select Edit.

   

2. Select the organization role that the user should have, then click on Next.

   

3. Select the desired role for the user on each database.

   

4. Click on Update to apply the changes, or click on Back to go back to the Organization role step.

Remove users

You must have the Owner role to remove users.

As an account owner, you can remove a user from the account. To remove a user, do the following:

1. On the Users page, click on ... on the user that you want to edit and select Remove.

   

2. Click on Delete to confirm that you want to remove this user from the account, or click on Close to cancel the operation.