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

     1  set global enable_privilege_cache = off;
     2  drop user if exists anne,bill;
     3  create user anne identified by '111' , bill identified by '111';
     4  drop role if exists intern,lead,newrole,rolex,dev,test,rx;
     5  create role intern,lead,newrole,rolex,dev,test,rx;
     6  grant connect on account * to intern,lead,newrole,rolex;
     7  grant intern to anne;
     8  grant dev to intern;
     9  grant test to dev;
    10  grant create table on database * to intern with grant option;
    11  grant create database on account * to dev;
    12  grant drop database on account * to dev with grant option;
    13  grant drop table on database * to test with grant option;
    14  grant lead to anne with grant option;
    15  grant dev to lead with grant option;
    16  grant create table on database * to lead with grant option;
    17  grant newrole to anne;
    18  grant create table on database * to newrole with grant option;
    19  grant dev to newrole with grant option;
    20  grant newrole to lead with grant option;
    21  grant newrole to anne;
    22  grant newrole to rolex with grant option;
    23  grant rolex to anne;
    24  drop database if exists t;
    25  create database t;
    26  use t;
    27  create table A(a int);
    28  drop table A;
    29  grant create table on database * to rx;
    30  grant create database on account * to rx;
    31  internal error: do not have privilege to execute the statement
    32  grant drop database on account * to rx;
    33  internal error: do not have privilege to execute the statement
    34  grant drop table on database * to rx;
    35  grant test to rx,bill;
    36  internal error: do not have privilege to execute the statement
    37  grant dev to rx,bill;
    38  internal error: do not have privilege to execute the statement
    39  grant intern to rx,bill;
    40  internal error: do not have privilege to execute the statement
    41  grant lead to rx,bill;
    42  internal error: do not have privilege to execute the statement
    43  grant newrole to rx,bill;
    44  internal error: do not have privilege to execute the statement
    45  grant rolex to rx,bill;
    46  internal error: do not have privilege to execute the statement
    47  set secondary role all;
    48  grant test to rx,bill;
    49  internal error: do not have privilege to execute the statement
    50  grant dev to rx,bill;
    51  grant intern to rx,bill;
    52  internal error: do not have privilege to execute the statement
    53  grant lead to rx,bill;
    54  grant newrole to rx,bill;
    55  grant rolex to rx,bill;
    56  internal error: do not have privilege to execute the statement
    57  set role lead;
    58  drop database if exists t;
    59  create database t;
    60  use t;
    61  create table A(a int);
    62  drop table A;
    63  grant create table on database * to rx;
    64  grant create database on account * to rx;
    65  internal error: do not have privilege to execute the statement
    66  grant drop database on account * to rx;
    67  grant drop table on database * to rx;
    68  grant test to rx,bill;
    69  internal error: do not have privilege to execute the statement
    70  grant dev to rx,bill;
    71  grant intern to rx,bill;
    72  internal error: do not have privilege to execute the statement
    73  grant lead to rx,bill;
    74  grant newrole to rx,bill;
    75  grant rolex to rx,bill;
    76  internal error: do not have privilege to execute the statement
    77  set secondary role all;
    78  grant test to rx,bill;
    79  internal error: do not have privilege to execute the statement
    80  grant dev to rx,bill;
    81  grant intern to rx,bill;
    82  internal error: do not have privilege to execute the statement
    83  grant lead to rx,bill;
    84  grant newrole to rx,bill;
    85  grant rolex to rx,bill;
    86  internal error: do not have privilege to execute the statement
    87  set role newrole;
    88  drop database if exists t;
    89  create database t;
    90  use t;
    91  create table A(a int);
    92  drop table A;
    93  grant create table on database * to rx;
    94  grant create database on account * to rx;
    95  internal error: do not have privilege to execute the statement
    96  grant drop database on account * to rx;
    97  grant drop table on database * to rx;
    98  grant test to rx,bill;
    99  internal error: do not have privilege to execute the statement
   100  grant dev to rx,bill;
   101  grant intern to rx,bill;
   102  internal error: do not have privilege to execute the statement
   103  grant lead to rx,bill;
   104  internal error: do not have privilege to execute the statement
   105  grant newrole to rx,bill;
   106  internal error: do not have privilege to execute the statement
   107  grant rolex to rx,bill;
   108  internal error: do not have privilege to execute the statement
   109  set secondary role all;
   110  grant test to rx,bill;
   111  internal error: do not have privilege to execute the statement
   112  grant dev to rx,bill;
   113  grant intern to rx,bill;
   114  internal error: do not have privilege to execute the statement
   115  grant lead to rx,bill;
   116  grant newrole to rx,bill;
   117  grant rolex to rx,bill;
   118  internal error: do not have privilege to execute the statement
   119  set role rolex;
   120  drop database if exists t;
   121  create database t;
   122  use t;
   123  create table A(a int);
   124  drop table A;
   125  grant create table on database * to rx;
   126  grant create database on account * to rx;
   127  internal error: do not have privilege to execute the statement
   128  grant drop database on account * to rx;
   129  grant drop table on database * to rx;
   130  grant test to rx,bill;
   131  internal error: do not have privilege to execute the statement
   132  grant dev to rx,bill;
   133  grant intern to rx,bill;
   134  internal error: do not have privilege to execute the statement
   135  grant lead to rx,bill;
   136  internal error: do not have privilege to execute the statement
   137  grant newrole to rx,bill;
   138  grant rolex to rx,bill;
   139  internal error: do not have privilege to execute the statement
   140  set secondary role all;
   141  grant test to rx,bill;
   142  internal error: do not have privilege to execute the statement
   143  grant dev to rx,bill;
   144  grant intern to rx,bill;
   145  internal error: do not have privilege to execute the statement
   146  grant lead to rx,bill;
   147  grant newrole to rx,bill;
   148  grant rolex to rx,bill;
   149  internal error: do not have privilege to execute the statement
   150  drop database t;
   151  drop user anne,bill;
   152  drop role intern,lead,newrole,rolex,dev,test,rx;
   153  set global enable_privilege_cache = on;