ALTER USER
ALTER USER modifies user information, including password, authentication method, default roles, and user properties (supported from v3.3.3 onwards).
CREATE ROLE
CREATE ROLE creates a role.
CREATE USER
CREATE USER creates a StarRocks user.
DROP ROLE
DROP ROLE drops a role.
DROP USER
DROP USER drops a specified user identity.
EXECUTE AS
Use the IMPERSONATE privilege with EXECUTE AS statements to switch the execution context of the current session to the impersonated user.
GRANT
Grants roles or privileges on specific objects to a user, a role, or an external group.
REVOKE
Use REVOKE to remove specific privileges or roles from a user or a role.
SET DEFAULT ROLE
SET DEFAULT ROLE sets the roles that are activated by default when the user connects to the server.
SET PASSWORD
SET PASSWORD changes the login password for users.
SET ROLE
SET ROLE activates roles, along with all of its associated privileges and nested roles, for the current session.
SHOW AUTHENTICATION
SHOW AUTHENTICATION displays the authentication information of the current user or all users in the current cluster.
SHOW GRANTS
SHOW GRANTS displays all the privileges that have been granted to a user or role.
SHOW PROPERTY
SHOW PROPERTY displays properties of a user, including the maximum number of connections, the default catalog, and the default database.
SHOW ROLES
SHOW ROLES displays all roles in the system.
SHOW USERS
SHOW USERS displays all users in the system.