Change User Roles

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

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 ()