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

     1  drop user if exists anne,bill;
     2  create user anne identified by '111' , bill identified by '111';
     3  drop role if exists intern,lead,newrole,rolex,dev,test,rx;
     4  create role intern,lead,newrole,rolex,dev,test,rx;
     5  grant connect on account * to intern,lead,newrole,rolex;
     6  grant intern to anne;
     7  grant dev to intern;
     8  grant test to dev;
     9  grant create table on database * to intern with grant option;
    10  grant create database on account * to dev;
    11  grant drop database on account * to dev with grant option;
    12  grant drop table on database * to test with grant option;
    13  grant lead to anne with grant option;
    14  grant dev to lead with grant option;
    15  grant create table on database * to lead with grant option;
    16  grant newrole to anne;
    17  grant create table on database * to newrole with grant option;
    18  grant dev to newrole with grant option;
    19  grant newrole to lead with grant option;
    20  grant newrole to anne;
    21  grant newrole to rolex with grant option;
    22  grant rolex to anne;
    23  drop database if exists t;
    24  create database t;
    25  use t;
    26  create table A(a int);
    27  drop table A;
    28  grant create table on database * to rx;
    29  grant create database on account * to rx;
    30  internal error: do not have privilege to execute the statement
    31  grant drop database on account * to rx;
    32  internal error: do not have privilege to execute the statement
    33  grant drop table on database * to rx;
    34  internal error: do not have privilege to execute the statement
    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  internal error: do not have privilege to execute the statement
    69  grant test to rx,bill;
    70  internal error: do not have privilege to execute the statement
    71  grant dev to rx,bill;
    72  grant intern to rx,bill;
    73  internal error: do not have privilege to execute the statement
    74  grant lead to rx,bill;
    75  grant newrole to rx,bill;
    76  grant rolex to rx,bill;
    77  internal error: do not have privilege to execute the statement
    78  set secondary role all;
    79  grant test to rx,bill;
    80  internal error: do not have privilege to execute the statement
    81  grant dev to rx,bill;
    82  grant intern to rx,bill;
    83  internal error: do not have privilege to execute the statement
    84  grant lead to rx,bill;
    85  grant newrole to rx,bill;
    86  grant rolex to rx,bill;
    87  internal error: do not have privilege to execute the statement
    88  set role newrole;
    89  drop database if exists t;
    90  create database t;
    91  use t;
    92  create table A(a int);
    93  drop table A;
    94  grant create table on database * to rx;
    95  grant create database on account * to rx;
    96  internal error: do not have privilege to execute the statement
    97  grant drop database on account * to rx;
    98  grant drop table on database * to rx;
    99  internal error: do not have privilege to execute the statement
   100  grant test to rx,bill;
   101  internal error: do not have privilege to execute the statement
   102  grant dev to rx,bill;
   103  grant intern to rx,bill;
   104  internal error: do not have privilege to execute the statement
   105  grant lead to rx,bill;
   106  internal error: do not have privilege to execute the statement
   107  grant newrole to rx,bill;
   108  internal error: do not have privilege to execute the statement
   109  grant rolex to rx,bill;
   110  internal error: do not have privilege to execute the statement
   111  set secondary role all;
   112  grant test to rx,bill;
   113  internal error: do not have privilege to execute the statement
   114  grant dev to rx,bill;
   115  grant intern to rx,bill;
   116  internal error: do not have privilege to execute the statement
   117  grant lead to rx,bill;
   118  grant newrole to rx,bill;
   119  grant rolex to rx,bill;
   120  internal error: do not have privilege to execute the statement
   121  set role rolex;
   122  drop database if exists t;
   123  create database t;
   124  use t;
   125  create table A(a int);
   126  drop table A;
   127  grant create table on database * to rx;
   128  grant create database on account * to rx;
   129  internal error: do not have privilege to execute the statement
   130  grant drop database on account * to rx;
   131  grant drop table on database * to rx;
   132  internal error: do not have privilege to execute the statement
   133  grant test to rx,bill;
   134  internal error: do not have privilege to execute the statement
   135  grant dev to rx,bill;
   136  grant intern to rx,bill;
   137  internal error: do not have privilege to execute the statement
   138  grant lead to rx,bill;
   139  internal error: do not have privilege to execute the statement
   140  grant newrole to rx,bill;
   141  grant rolex to rx,bill;
   142  internal error: do not have privilege to execute the statement
   143  set secondary role all;
   144  grant test to rx,bill;
   145  internal error: do not have privilege to execute the statement
   146  grant dev to rx,bill;
   147  grant intern to rx,bill;
   148  internal error: do not have privilege to execute the statement
   149  grant lead to rx,bill;
   150  grant newrole to rx,bill;
   151  grant rolex to rx,bill;
   152  internal error: do not have privilege to execute the statement
   153  drop database t;
   154  drop user anne,bill;
   155  drop role intern,lead,newrole,rolex,dev,test,rx;