Delete Users

This section explains how to delete system administration users.

System administration users are not the same as database users.

This procedure is carried out using ConfD.

Prerequisites

To perform this task you must be a member of the exaadm group.

Procedure

The following examples use ConfD through the command-line tool confd_client, which is accessible on all database nodes. You can also access ConfD through XML-RPC in your own Python programs. For more information, see ConfD.

Placeholder values are indicated with UPPERCASE characters. Replace the placeholders with your own values.

  1. Connect to EXAClusterOS (COS) using c4 connect -t<DEPLOYMENT>/cos. For example:

    c4 connect -t1/cos

    If you do not specify a node, you will be connected to the first node in the deployment. If the cluster is configured with an access node, the first node is the access node (usually n10). The COS command prompt will tell you which node you are currently connected to: 

    [root@n10 ~]#

    For more information about c4 commands, see Exasol Deployment Tool (c4).

  2. To find the user name, use the ConfD job user_list: 

    confd_client -c user_list

    In the following example output, the user name is admin2.

    admin2:
      additional_groups: []
      authorized_keys: []
      group: exaadm
      id: 1005

  3. To delete a user, use the ConfD job user_delete. For example: 

    confd_client -c user_delete -a '{username: USERNAME}'

Verification

To verify that the user has been deleted, use the ConfD job user_list: 

confd_client -c user_list

The user is no longer listed.

See Also