Edit Users

This section explains how you can edit users from the EXAoperation user interface or using XML-RPC.

These are not the database users. These are EXAoperation users.

Using EXAoperation

Do the following to edit the login details of a user:

  1. In EXAoperation, select Configuration > Access Management.
  2. In the Users tab, select the user you want to edit and click Edit.

    Edit a user in Exasol

  3. 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).
  4. Click Apply.


Do the following to edit a user:

  1. Run the following commands to import the XML-RPC packages:
  2. from xmlrpc.client import ServerProxy
    from xmlrpc.client import ServerProxy as xmlrpc

  3. Run the following command to create a connection with your Exasol cluster:
  4. import ssl
    server = ServerProxy ('https://user:password@<IP_Address>/cluster1', context=ssl._create_unverified_context (), allow_none = True)

  5. Run the following command to edit the user. Specify the new password or title in the command.
  6. server.editUser('<username>', {'password':'<password>', 'user_title':'<user title>'})
    #for example,
    server.editUser('test user', {'password':'test12345', 'user_title':'This is a test user'})