User Management

A system operator can use TDengine CLI taos to create or remove users or change passwords. The SQL commands are documented below:

Create User

  1. CREATE USER <user_name> PASS <'password'>;

When creating a user and specifying the user name and password, the password needs to be quoted using single quotes.

Drop User

  1. DROP USER <user_name>;

Dropping a user can only be performed by root.

Change Password

  1. ALTER USER <user_name> PASS <'password'>;

To keep the case of the password when changing password, the password needs to be quoted using single quotes.

Change Privilege

  1. ALTER USER <user_name> PRIVILEGE <write|read>;

The privileges that can be changed to are read or write without single quotes.

Note：there is another privilege super, which is not allowed to be authorized to any user.

Show Users

  1. SHOW USERS;
User Management - 图1note

In SQL syntax, < > means the part that needs to be input by the user, excluding the < > itself.