github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/role6_createuser.result (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  internal error: the role moadmin can not be granted to non administration user u5
     7  create user u7 identified by '111', u8 identified by '111' default role rx;
     8  internal error: there is no role rx
     9  drop role if exists r1;
    10  create role r1;
    11  create user u9 identified by '111', u10 identified by '111' default role r1;
    12  drop user if exists u1,u2,u3,u4,u5,u6,u7,u8,u9,u10;
    13  drop role r1;
    14  create account acc_idx ADMIN_NAME 'root' IDENTIFIED BY '123456';
    15  create database db1;
    16  use db1;
    17  drop table if exists t;
    18  create table t(
    19  a int,
    20  b int,
    21  c int,
    22  primary key(a)
    23  );
    24  show tables;
    25  Tables_in_db1
    26  t
    27  alter user 'root' identified by '111';
    28  use db1;
    29  show tables;
    30  Tables_in_db1
    31  t
    32  drop database db1;
    33  drop account acc_idx;
    34  set global enable_privilege_cache = on;