ποΈ 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. After a role is created, you can grant privileges to the role and then assign this role to a user or another role. This way, the privileges associated with this role are passed on to users or roles.
ποΈ CREATE USER
CREATE USER creates a StarRocks user. In StarRocks, a "user_identity" uniquely identifies a user. From v3.3.3, StarRocks supports setting user properties when creating a user.
ποΈ DROP ROLE
DROP ROLE drops a role. If a role has been granted to a user, the user still has the privileges associated with this role even after the role is dropped.
ποΈ 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
GRANT grants one or more privileges on specific objects to a user or a role.
ποΈ REVOKE
Use REVOKE to remove specific privileges or roles from a user or a role. For the privileges supported by StarRocks, see Privileges supported by StarRocks.
ποΈ 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. The ALTER USER command can also be used to change a password.
ποΈ SET ROLE
SET ROLE activates roles, along with all of its associated privileges and nested roles, for the current session. After the role is activated, users can use this role to perform operations.
ποΈ 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. Currently, only the maximum number of connections can be viewed using this command.
ποΈ SHOW ROLES
SHOW ROLES displays all roles in the system. You can use SHOW GRANTS FOR ROLE ; to view the privileges of a specific role. For more information, see SHOW GRANTS.
ποΈ SHOW USERS
SHOW USERS displays all users in the system. Users mentioned here are user identities, not user names. For more information about user identities, see CREATE USER. This command is supported from v3.0.