Add, Edit, and Delete Users
This section explains how you can add, edit, and delete users from the EXAoperation user interface.
These are not the database users. These are EXAoperation users.
Add a User
Authenticated by a Password
Using EXAoperation
Do the following to add a user that is authenticated by password:
- In EXAoperation, select Configuration > Access Management.
- In the Users tab, click Add.
- Enter the following information:
- Login: Login ID of the user.
- Title: User's title.
- Description: (Optional) Description of the user.
- Identified by: Select Internal.
- Password: Password of the user.
- Repeat password: Repeat the password of the user.
- Click Add.
Using XML-RPC
Do the following to add a user using XML-RPC:
- Run the following commands to import the XML-RPC packages:
- Run the following command to create a connection with your Exasol cluster:
- Run the following command to create a user.
import ssl
server = ServerProxy ('https://user:password@<IP_Address>/cluster1', context=ssl._create_unverified_context (), allow_none = True)
A new user is created with default role User. To know how to change the user role, see Change a User's Role
Authenticated by LDAP
Using EXAoperation
Do the following to add a user that is authenticated by LDAP:
- In EXAoperation, select Configuration > Access Management.
- In the Users tab, click Add.
- Enter the following information:
- Login: Login ID of the user.
- Title: User's title.
- Description: (Optional) Description of the user.
- Identified by: Select LDAP.
- LDAP Server: LDAP server details.
- LDAP User DN: User's distinguished name.
- Click Add.
Using XML-RPC
Do the following to add a user with LDAP authentication using XML-RPC:
- Run the following commands to import the XML-RPC packages:
- Run the following command to create a connection with your Exasol cluster:
- Run the following command to create a user.
import ssl
server = ServerProxy ('https://user:password@<IP_Address>/cluster1', context=ssl._create_unverified_context (), allow_none = True)
You have to provide a password for the user even if you choose LDAP authentication.
A new user is created with default role User. To know how to change the user role, see Change a User's Role
Edit a User
You can edit the following for a user through EXAoperation user interface or through XML-RPC.
Edit Login Details
Using EXAoperation
Do the following to edit the login details of a user:
- In EXAoperation, select Configuration > Access Management.
- In the Users tab, select the user you want to edit and click Edit.
- Change the following according to your requirement:
- Login: Login ID of the user.
- Title: User's title.
- Description: (Optional) Description of the user.
- Identified by: If the user is identified by a password, you can change the old password. If the user is identified by LDAP, you can modify the LDAP details. You can also change how the user is authenticated (from password to LDAP or other way around).
- Click Apply.
Using XML-RPC
Do the following to edit a user:
- Run the following commands to import the XML-RPC packages:
- Run the following command to create a connection with your Exasol cluster:
- Run the following command to edit the user. Specify the new password or title in the command.
import ssl
server = ServerProxy ('https://user:password@<IP_Address>/cluster1', context=ssl._create_unverified_context (), allow_none = True)
Change a User's Role
EXAoperation has the following user roles:
- Master: Has all possible rights and permissions
- Administrator: Can manage the cluster, but cannot change the license, change the password for disk encryption, or assign the master role to a user.
- Supervisor: Is able to view the cluster configuration, but is not able to make any changes to the system.
- User: Can only view the basic state of nodes and databases.
Using EXAoperation
Do the following to change a user's role:
- In EXAoperation, select Configuration > Access Management.
- In the Roles tab, select a user role from the drop-down Role for a user.
- Click Apply.
Using XML-RPC
Do the following to edit a user role using XML-RPC:
- Run the following commands to import the XML-RPC packages:
- Run the following command to create a connection with your Exasol cluster:
- Run the following command to edit the user role.
server.grantRole('<object_name>', '<user ID>', '<new role name')
#for example,
server.grantRole('db_exa_db1','8', 'Master')You can run the following commands to check object name and user ID for the above command.
import ssl
server = ServerProxy ('https://user:password@<IP_Address>/cluster1', context=ssl._create_unverified_context (), allow_none = True)
Delete a User
Using EXAoperation
Do the following to delete a user:
- In EXAoperation, select Configuration > Access Management.
- In the Users tab, select the user you want to delete and click Delete.
Using XML-RPC
Do the following to add a user with LDAP authentication using XML-RPC:
- Run the following commands to import the XML-RPC packages:
- Run the following command to create a connection with your Exasol cluster:
- Run any of the following commands to create a user.