用户账户管理

📄️ ALTER USER

ALTER USER modifies user information, including password, authentication method, default roles, and user properties (supported from v3.3.3 onwards).

CREATE ROLE creates a role.

CREATE USER creates a StarRocks user.

DROP ROLE drops a role.

DROP USER drops a specified user identity.

Use the IMPERSONATE privilege with EXECUTE AS statements to switch the execution context of the current session to the impersonated user.

Grants roles or privileges on specific objects to a user, a role, or an external group.

Use REVOKE to remove specific privileges or roles from a user or a role.

SET DEFAULT ROLE sets the roles that are activated by default when the user connects to the server.

SET PASSWORD changes the login password for users.

SET ROLE activates roles, along with all of its associated privileges and nested roles, for the current session.

SHOW AUTHENTICATION displays the authentication information of the current user or all users in the current cluster.

SHOW GRANTS displays all the privileges that have been granted to a user or role.

SHOW PROPERTY displays properties of a user, including the maximum number of connections, the default catalog, and the default database.

SHOW ROLES displays all roles in the system.

SHOW USERS displays all users in the system.