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

     1  set global enable_privilege_cache = off;
     2  drop user if exists u1,u2,u3,u4,u5,u6,u7,u8,u9,u10;
     3  create user u1 identified by '111', u2 identified by '111' default role public;
     4  create user u3 identified by '111', u4 identified by '111';
     5  create user u5 identified by '111', u6 identified by '111' default role moadmin;
     6  create user u7 identified by '111', u8 identified by '111' default role rx;
     7  
     8  drop role if exists r1;
     9  create role r1;
    10  create user u9 identified by '111', u10 identified by '111' default role r1;
    11  
    12  
    13  drop user if exists u1,u2,u3,u4,u5,u6,u7,u8,u9,u10;
    14  drop role r1;
    15  
    16  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
    17  -- @session:id=1&user=acc_idx:root&password=123456
    18  create database db1;
    19  use db1;
    20  drop table if exists t;
    21  create table t(
    22                    a int,
    23                    b int,
    24                    c int,
    25                    primary key(a)
    26  );
    27  show tables;
    28  alter user 'root' identified by '111';
    29  -- @session
    30  -- @session:id=2&user=acc_idx:root&password=111
    31  use db1;
    32  show tables;
    33  drop database db1;
    34  -- @session
    35  drop account acc_idx;
    36  set global enable_privilege_cache = on;