Using User Management Commands

• Use CREATE USER command to create a Doris user (without a role).

  CREATE USER 'Jack' IDENTIFIED BY 'password';
  
  

  Table 1 Parameters

  Parameter	Description
  Jack	Username
  password	Password of the created user

  Note

  You can run the command to specify an IP address.

  CREATE USER 'jack02' @'192.168.%'  identified by '123456'  DEFAULT ROLE 'default_role';
  
  

• Use CREATE USER command to create a Doris user (without the default role assigned).

  CREATE USER 'jeo' IDENTIFIED BY 'password' DEFAULT ROLE 'default_role';
  
  

Use the ALTER USER command to change the password of a user.

ALTER USER 'Jack' IDENTIFIED BY "password";

• Assign a role to the user.

  GRANT 'role1','role2' TO 'jack'@'%';
  
  

  Table 2 Parameters

  Parameter	Description
  role	Created role
  jack	Name of the new user

• Revoke the role assigned to the user.

  REVOKE 'role1' FROM 'candy';