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

     1  set global enable_privilege_cache = off;
     2  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
     3  create role role1;
     4  grant create database on account * to role1;
     5  create user user1 identified by '123456' default role role1;
     6  create database db1;
     7  create table db1.t1(a int);
     8  insert into db1.t1 values(1);
     9  select * from db1.t1;
    10  a
    11  1
    12  truncate table db1.t1;
    13  insert into db1.t1 values(2);
    14  select * from db1.t1;
    15  a
    16  2
    17  drop account default_1;
    18  create account default_1 ADMIN_NAME admin IDENTIFIED BY '111111';
    19  create role role1;
    20  grant create database on account * to role1;
    21  create user user1 identified by '123456' default role role1;
    22  create database db1;
    23  create role role2;
    24  grant create table on database db1 to role2;
    25  create user user2 identified by '123456';
    26  grant role1,role2 to user2;
    27  create table db1.t2(a int);
    28  internal error: do not have privilege to execute the statement
    29  set role role2;
    30  create table db1.t2(a int);
    31  insert into db1.t2 values(1);
    32  insert into db1.t2 values(2);
    33  insert into db1.t2 values(3);
    34  set role public;
    35  create table db1.t3(a int);
    36  internal error: do not have privilege to execute the statement
    37  set secondary role all;
    38  create table db1.t3(a int);
    39  select * from db1.t2;
    40  internal error: do not have privilege to execute the statement
    41  grant all on table db1.t2 to role1;
    42  select * from db1.t2;
    43  a
    44  1
    45  2
    46  3
    47  drop account default_1;
    48  set global enable_privilege_cache = on;