Skip to main content

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

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

DROP USER <user_name>;

Dropping a user can only be performed by root.

Change Password

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

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

SHOW USERS;
note

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