ユーザーアカウント管理
ALTER USER
ALTER USER modifies user information including password, authentication method, and default roles.
CREATE ROLE
CREATE ROLE creates a new role for assigning permissions and controlling user access.
CREATE USER
CREATE USER creates a new StarRocks user with optional authentication and properties.
DROP ROLE
DROP ROLE removes a role from StarRocks.
DROP USER
DROP USER removes a specified user identity from StarRocks.
EXECUTE AS
Use IMPERSONATE privilege with EXECUTE AS to switch the execution context to another user.
GRANT
Grants roles or privileges on specific objects to users, roles, or external groups.
REVOKE
REVOKE removes specific privileges or roles from a user or role.
SET DEFAULT ROLE
SET DEFAULT ROLE sets roles that activate by default when a user connects.
SET PASSWORD
SET PASSWORD changes the login password for users.
SET ROLE
SET ROLE activates roles with their associated privileges for the current session.
SHOW AUTHENTICATION
SHOW AUTHENTICATION displays authentication information of users in the cluster.
SHOW CREATE USER
SHOW CREATE USER returns the CREATE USER statement that reproduces a user.
SHOW GRANTS
SHOW GRANTS displays all privileges and roles granted to a user or role.
SHOW PROPERTY
SHOW PROPERTY displays user properties like maximum connections, default catalog, and database.
SHOW ROLES
システム内のすべてのロールを表示します。
SHOW USERS
システム内のすべてのユーザーを表示します。