ποΈ 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.
