github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/owner.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  create table db1.t1(a int);
    11  insert into db1.t1 values(1);
    12  select * from db1.t1;
    13  truncate table db1.t1;
    14  -- @bvt:issue#10126
    15  insert into db1.t1 values(2);
    16  select * from db1.t1;
    17  -- @bvt:issue
    18  -- @session
    19  drop account default_1;
    20  
    21  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
    22  -- @session:id=3&user=default_1:admin&password=111111
    23  create role role1;
    24  grant create database on account * to role1;
    25  create user user1 identified by '123456' default role role1;
    26  -- @session
    27  -- @session:id=4&user=default_1:user1:role1&password=123456
    28  create database db1;
    29  -- @session
    30  -- @session:id=5&user=default_1:admin&password=111111
    31  create role role2;
    32  grant create table on database db1 to role2;
    33  create user user2 identified by '123456';
    34  grant role1,role2 to user2;
    35  -- @session
    36  -- @session:id=6&user=default_1:user2&password=123456
    37  create table db1.t2(a int);
    38  set role role2;
    39  create table db1.t2(a int);
    40  insert into db1.t2 values(1);
    41  insert into db1.t2 values(2);
    42  insert into db1.t2 values(3);
    43  set role public;
    44  create table db1.t3(a int);
    45  set secondary role all;
    46  create table db1.t3(a int);
    47  -- @session
    48  -- @session:id=7&user=default_1:user2:role1&password=123456
    49  select * from db1.t2;
    50  -- @session
    51  -- @session:id=8&user=default_1:user2:role2&password=123456
    52  grant all on table db1.t2 to role1;
    53  -- @session
    54  -- @session:id=9&user=default_1:user2:role1&password=123456
    55  select * from db1.t2;
    56  -- @session
    57  drop account default_1;
    58  set global enable_privilege_cache = on;