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.

Edit Login Details

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.

Using XML-RPC

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'})

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:

  1. In EXAoperation, select Configuration > Access Management.
  2. In the Roles tab, select a user role from the drop-down Role for a user.

    Change a user's role in Exasol

  3. Click Apply.

Using XML-RPC

Do the following to edit a user role using XML-RPC:

  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 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.

    server.getUserByName ('<username>')
    server.listObjects ()