github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/owner1.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 role role2;
     8  grant create table on database db1 to role2;
     9  create user user2 identified by '123456';
    10  grant role1,role2 to user2;
    11  set role role2;
    12  create table db1.t2(a int);
    13  set secondary role all;
    14  create table db1.t3(a int);
    15  set role role2;
    16  drop table db1.t3;
    17  internal error: do not have privilege to execute the statement
    18  drop table db1.t2;
    19  drop table db1.t3;
    20  drop database db1;
    21  drop account default_1;
    22  set global enable_privilege_cache = on;