github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/tenant/privilege/role6_createuser.sql (about)

     1  drop user if exists u1,u2,u3,u4,u5,u6,u7,u8,u9,u10;
     2  create user u1 identified by '111', u2 identified by '111' default role public;
     3  create user u3 identified by '111', u4 identified by '111';
     4  create user u5 identified by '111', u6 identified by '111' default role moadmin;
     5  create user u7 identified by '111', u8 identified by '111' default role rx;
     6  
     7  drop role if exists r1;
     8  create role r1;
     9  create user u9 identified by '111', u10 identified by '111' default role r1;
    10  
    11  
    12  drop user if exists u1,u2,u3,u4,u5,u6,u7,u8,u9,u10;
    13  drop role r1;