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

     1  set global enable_privilege_cache = off;
     2  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
     3  -- @session:id=1&user=default_1:admin&password=111111
     4  create role role1;
     5  grant create database on account * to role1;
     6  create user user1 identified by '123456' default role role1;
     7  -- @session
     8  -- @session:id=2&user=default_1:user1:role1&password=123456
     9  create database db1;
    10  -- @session
    11  -- @session:id=3&user=default_1:admin&password=111111
    12  create role role2;
    13  grant create table on database db1 to role2;
    14  create user user2 identified by '123456';
    15  grant role1,role2 to user2;
    16  -- @session
    17  -- @session:id=4&user=default_1:user2&password=123456
    18  set role role2;
    19  create table db1.t2(a int);
    20  set secondary role all;
    21  create table db1.t3(a int);
    22  set role role2;
    23  drop table db1.t3;
    24  drop table db1.t2;
    25  -- @session
    26  -- @session:id=5&user=default_1:user1:role1&password=123456
    27  drop table db1.t3;
    28  drop database db1;
    29  -- @session
    30  drop account default_1;
    31  set global enable_privilege_cache = on;