github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/tenant/privilege/create_user_default_role.result (about)

     1  drop role if exists r1;
     2  create role r1;
     3  drop user if exists u1;
     4  create user u1 identified by '111' default role r1;
     5  show tables;
     6  internal error: do not have privilege to execute the statement
     7  use mo_catalog;
     8  internal error: do not have privilege to execute the statement
     9  create database t;
    10  internal error: do not have privilege to execute the statement
    11  grant show databases on account * to r1;
    12  grant show tables on database * to r1;
    13  use mo_catalog;
    14  internal error: do not have privilege to execute the statement
    15  show tables;
    16  not connect to a database
    17  create database t;
    18  internal error: do not have privilege to execute the statement
    19  grant connect on account * to r1;
    20  use mo_catalog;
    21  show tables;
    22  tables_in_mo_catalog
    23  mo_user
    24  mo_account
    25  mo_role
    26  mo_user_grant
    27  mo_role_grant
    28  mo_role_privs
    29  mo_user_defined_function
    30  mo_mysql_compatbility_mode
    31  mo_columns
    32  mo_tables
    33  mo_database
    34  create database t;
    35  internal error: do not have privilege to execute the statement
    36  grant create database on account * to r1;
    37  create database t;
    38  use t;
    39  create table A(a int);
    40  internal error: do not have privilege to execute the statement
    41  grant create table on database * to r1;
    42  use t;
    43  create table A(a int);
    44  insert into A values (1),(1);
    45  internal error: do not have privilege to execute the statement
    46  grant insert on table t.* to r1;
    47  use t;
    48  insert into A values (1),(1);
    49  select a from A;
    50  internal error: do not have privilege to execute the statement
    51  grant select on table t.* to r1;
    52  use t;
    53  select a from A;
    54  a
    55  1
    56  1
    57  update A set a = 2 where a = 1;
    58  internal error: do not have privilege to execute the statement
    59  update A set a = 2;
    60  internal error: do not have privilege to execute the statement
    61  grant update on table t.* to r1;
    62  use t;
    63  update A set a = 2 where a = 1;
    64  update A set a = 2;
    65  delete from A where a = 2;
    66  internal error: do not have privilege to execute the statement
    67  delete from A;
    68  internal error: do not have privilege to execute the statement
    69  grant delete on table t.* to r1;
    70  use t;
    71  delete from A where a = 2;
    72  delete from A;
    73  select a from A;
    74  a
    75  drop table A;
    76  internal error: do not have privilege to execute the statement
    77  grant drop table on database t to r1;
    78  use t;
    79  drop table A;
    80  create database s;
    81  use s;
    82  create table B(b int);
    83  insert into B values (1),(1);
    84  internal error: do not have privilege to execute the statement
    85  grant select,insert,update,delete on table s.* to r1;
    86  use s;
    87  insert into B values (1),(1);
    88  select b from B;
    89  b
    90  1
    91  1
    92  update B set b = 2 where b=1;
    93  update B set b = 2;
    94  delete from B where b = 1;
    95  delete from B;
    96  drop table B;
    97  internal error: do not have privilege to execute the statement
    98  grant drop table on database s to r1;
    99  use s;
   100  drop table B;
   101  drop database t;
   102  internal error: do not have privilege to execute the statement
   103  drop database s;
   104  internal error: do not have privilege to execute the statement
   105  create database v;
   106  use v;
   107  grant create table,drop table on database v to r1;
   108  use v;
   109  create table A(a int);
   110  create table B(b int);
   111  create table C(c int);
   112  create table D(d int);
   113  create table E(e int);
   114  create table F(f int);
   115  create table G(g int);
   116  create table H(h int);
   117  grant select on table v.A to r1;
   118  use v;
   119  select * from A,B;
   120  internal error: do not have privilege to execute the statement
   121  select * from A,B where A.a = B.b;
   122  internal error: do not have privilege to execute the statement
   123  grant select on table v.B to r1;
   124  use v;
   125  select * from A,B;
   126  a    b
   127  select * from A,B where A.a = B.b;
   128  a    b
   129  update C,D set c = d+1 where c = d;
   130  internal error: do not have privilege to execute the statement
   131  grant update on table v.C to r1;
   132  use v;
   133  update C,D set c = d+1 where c = d;
   134  internal error: do not have privilege to execute the statement
   135  grant update on table v.D to r1;
   136  use v;
   137  update C,D set c = d+1 where c = d;
   138  use v;
   139  delete E,F from E,F where E.e = F.f;
   140  internal error: do not have privilege to execute the statement
   141  grant update on table v.E to r1;
   142  grant delete on table v.F to r1;
   143  use v;
   144  delete E,F from E,F where E.e = F.f;
   145  internal error: do not have privilege to execute the statement
   146  grant delete on table v.E to r1;
   147  use v;
   148  delete E,F from E,F where E.e = F.f;
   149  use v;
   150  insert into G select A.a from A,B where A.a = B.b;
   151  internal error: do not have privilege to execute the statement
   152  grant insert on table v.G to r1;
   153  use v;
   154  insert into G select A.a from A,B where A.a = B.b;
   155  drop database if exists t;
   156  internal error: do not have privilege to execute the statement
   157  drop database if exists s;
   158  internal error: do not have privilege to execute the statement
   159  drop database if exists v;
   160  internal error: do not have privilege to execute the statement
   161  grant drop database on account * to r1;
   162  drop database if exists t;
   163  drop database if exists s;
   164  drop database if exists v;
   165  drop role if exists r1;
   166  drop user if exists u1;