ユーザーアカウント管理

📄️ ALTER USER

ALTER USER modifies user information including password, authentication method, and default roles.

CREATE ROLE creates a new role for assigning permissions and controlling user access.

CREATE USER creates a new StarRocks user with optional authentication and properties.

DROP ROLE removes a role from StarRocks.

DROP USER removes a specified user identity from StarRocks.

Use IMPERSONATE privilege with EXECUTE AS to switch the execution context to another user.

Grants roles or privileges on specific objects to users, roles, or external groups.

REVOKE removes specific privileges or roles from a user or role.

SET DEFAULT ROLE sets roles that activate by default when a user connects.

SET PASSWORD changes the login password for users.

SET ROLE activates roles with their associated privileges for the current session.

SHOW AUTHENTICATION displays authentication information of users in the cluster.

SHOW GRANTS displays all privileges and roles granted to a user or role.

SHOW PROPERTY displays user properties like maximum connections, default catalog, and database.

システム内のすべてのロールを表示します。

システム内のすべてのユーザーを表示します。