This section explains how to add system administration users.
System administration users are not the same as database users.
This procedure is carried out using ConfD.
To perform this task you must be a member of the exaadm group.
The following examples use the command-line tool confd_client in a Linux terminal connected to a database node. For more information about how to use this tool, see ConfD.
Placeholder values are indicated with UPPERCASE characters. Replace the placeholders with your own values.
Connect to EXAClusterOS (COS) using
c4 connect -t<DEPLOYMENT>/cos. For example:
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:
For more information about c4 commands, see Exasol Deployment Tool (c4).
When creating a user, you must specify at least one group the user belongs to. Performing certain ConfD Jobs are only available to certain users or roles. Therefore, select a group that is able to perform all the commands you expect from the user. To identify available groups, use the ConfD job group_list:
exaadm: The Exasol administrator.
exabfsadm: Exasol BucketFS administrator
exadbadm: Exasol database administrator
exastoradm: Exasol storage administrator
exausers: Exasol users
root: Reserved for the root user.
To create a user, use the ConfD job user_create. For example:
Attempt to log in as the new user. If you encounter issues or do not want to log in as the new user, verify the user was created successfully by using the ConfD job user_list:
The output is similar to the following:
[root@n11 ~]# confd_client -c user_list