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

     1  set global enable_privilege_cache = off;
     2  drop role if exists role_r1;
     3  create role role_r1;
     4  drop database if exists d;
     5  create database d;
     6  use d;
     7  create table t(a int);
     8  revoke if exists create account on account * from role_r1,rx;
     9  revoke if exists drop account on account * from role_r1,rx;
    10  revoke if exists alter account on account * from role_r1,rx;
    11  revoke if exists create user on account * from role_r1,rx;
    12  revoke if exists drop user on account * from role_r1,rx;
    13  revoke if exists alter user on account * from role_r1,rx;
    14  revoke if exists create role on account * from role_r1,rx;
    15  revoke if exists drop role on account * from role_r1,rx;
    16  revoke if exists alter role on account * from role_r1,rx;
    17  revoke if exists create database on account * from role_r1,rx;
    18  revoke if exists drop database on account * from role_r1,rx;
    19  revoke if exists show databases on account * from role_r1,rx;
    20  revoke if exists connect on account * from role_r1,rx;
    21  revoke if exists manage grants on account * from role_r1,rx;
    22  revoke if exists all on account * from role_r1,rx;
    23  revoke if exists ownership on account * from role_r1,rx;
    24  revoke if exists ownership on account * from role_r1,rx;
    25  revoke if exists ownership on account * from role_r1,rx;
    26  revoke if exists show tables on database * from role_r1,rx;
    27  revoke if exists show tables on database *.* from role_r1,rx;
    28  revoke if exists show tables on database d from role_r1,rx;
    29  revoke if exists create table on database * from role_r1,rx;
    30  revoke if exists create table on database *.* from role_r1,rx;
    31  revoke if exists create table on database d from role_r1,rx;
    32  revoke if exists create view on database * from role_r1,rx;
    33  revoke if exists create view on database *.* from role_r1,rx;
    34  revoke if exists create view on database d from role_r1,rx;
    35  revoke if exists drop table on database * from role_r1,rx;
    36  revoke if exists drop table on database *.* from role_r1,rx;
    37  revoke if exists drop table on database d from role_r1,rx;
    38  revoke if exists drop view on database * from role_r1,rx;
    39  revoke if exists drop view on database *.* from role_r1,rx;
    40  revoke if exists drop view on database d from role_r1,rx;
    41  revoke if exists alter table on database * from role_r1,rx;
    42  revoke if exists alter table on database *.* from role_r1,rx;
    43  revoke if exists alter table on database d from role_r1,rx;
    44  revoke if exists alter view on database * from role_r1,rx;
    45  revoke if exists alter view on database *.* from role_r1,rx;
    46  revoke if exists alter view on database d from role_r1,rx;
    47  revoke if exists all on database * from role_r1,rx;
    48  revoke if exists all on database *.* from role_r1,rx;
    49  revoke if exists all on database d from role_r1,rx;
    50  revoke if exists ownership on database * from role_r1,rx;
    51  revoke if exists ownership on database *.* from role_r1,rx;
    52  revoke if exists ownership on database d from role_r1,rx;
    53  revoke if exists select on table * from role_r1,rx;
    54  revoke if exists select on table *.* from role_r1,rx;
    55  revoke if exists select on table d.* from role_r1,rx;
    56  revoke if exists select on table d.t from role_r1,rx;
    57  revoke if exists select on table t from role_r1,rx;
    58  revoke if exists insert on table * from role_r1,rx;
    59  revoke if exists insert on table *.* from role_r1,rx;
    60  revoke if exists insert on table d.* from role_r1,rx;
    61  revoke if exists insert on table d.t from role_r1,rx;
    62  revoke if exists insert on table t from role_r1,rx;
    63  revoke if exists update on table * from role_r1,rx;
    64  revoke if exists update on table *.* from role_r1,rx;
    65  revoke if exists update on table d.* from role_r1,rx;
    66  revoke if exists update on table d.t from role_r1,rx;
    67  revoke if exists update on table t from role_r1,rx;
    68  revoke if exists truncate on table * from role_r1,rx;
    69  revoke if exists truncate on table *.* from role_r1,rx;
    70  revoke if exists truncate on table d.* from role_r1,rx;
    71  revoke if exists truncate on table d.t from role_r1,rx;
    72  revoke if exists truncate on table t from role_r1,rx;
    73  revoke if exists delete on table * from role_r1,rx;
    74  revoke if exists delete on table *.* from role_r1,rx;
    75  revoke if exists delete on table d.* from role_r1,rx;
    76  revoke if exists delete on table d.t from role_r1,rx;
    77  revoke if exists delete on table t from role_r1,rx;
    78  revoke if exists reference on table * from role_r1,rx;
    79  revoke if exists reference on table *.* from role_r1,rx;
    80  revoke if exists reference on table d.* from role_r1,rx;
    81  revoke if exists reference on table d.t from role_r1,rx;
    82  revoke if exists reference on table t from role_r1,rx;
    83  revoke if exists index on table * from role_r1,rx;
    84  revoke if exists index on table *.* from role_r1,rx;
    85  revoke if exists index on table d.* from role_r1,rx;
    86  revoke if exists index on table d.t from role_r1,rx;
    87  revoke if exists index on table t from role_r1,rx;
    88  revoke if exists all on table * from role_r1,rx;
    89  revoke if exists all on table *.* from role_r1,rx;
    90  revoke if exists all on table d.* from role_r1,rx;
    91  revoke if exists all on table d.t from role_r1,rx;
    92  revoke if exists all on table t from role_r1,rx;
    93  revoke if exists ownership on table * from role_r1,rx;
    94  revoke if exists ownership on table *.* from role_r1,rx;
    95  revoke if exists ownership on table d.* from role_r1,rx;
    96  revoke if exists ownership on table d.t from role_r1,rx;
    97  revoke if exists ownership on table t from role_r1,rx;
    98  revoke if exists execute on table * from role_r1,rx;
    99  revoke if exists execute on table *.* from role_r1,rx;
   100  revoke if exists execute on table d.* from role_r1,rx;
   101  revoke if exists execute on table d.t from role_r1,rx;
   102  revoke if exists execute on table t from role_r1,rx;
   103  revoke create account on account * from role_r1,rx;
   104  revoke drop account on account * from role_r1,rx;
   105  revoke alter account on account * from role_r1,rx;
   106  revoke create user on account * from role_r1,rx;
   107  revoke drop user on account * from role_r1,rx;
   108  revoke alter user on account * from role_r1,rx;
   109  revoke create role on account * from role_r1,rx;
   110  revoke drop role on account * from role_r1,rx;
   111  revoke alter role on account * from role_r1,rx;
   112  revoke create database on account * from role_r1,rx;
   113  revoke drop database on account * from role_r1,rx;
   114  revoke show databases on account * from role_r1,rx;
   115  revoke connect on account * from role_r1,rx;
   116  revoke manage grants on account * from role_r1,rx;
   117  revoke all on account * from role_r1,rx;
   118  revoke ownership on account * from role_r1,rx;
   119  revoke ownership on account * from role_r1,rx;
   120  revoke ownership on account * from role_r1,rx;
   121  revoke show tables on database * from role_r1,rx;
   122  revoke show tables on database *.* from role_r1,rx;
   123  revoke show tables on database d from role_r1,rx;
   124  revoke create table on database * from role_r1,rx;
   125  revoke create table on database *.* from role_r1,rx;
   126  revoke create table on database d from role_r1,rx;
   127  revoke create view on database * from role_r1,rx;
   128  revoke create view on database *.* from role_r1,rx;
   129  revoke create view on database d from role_r1,rx;
   130  revoke drop table on database * from role_r1,rx;
   131  revoke drop table on database *.* from role_r1,rx;
   132  revoke drop table on database d from role_r1,rx;
   133  revoke drop view on database * from role_r1,rx;
   134  revoke drop view on database *.* from role_r1,rx;
   135  revoke drop view on database d from role_r1,rx;
   136  revoke alter table on database * from role_r1,rx;
   137  revoke alter table on database *.* from role_r1,rx;
   138  revoke alter table on database d from role_r1,rx;
   139  revoke alter view on database * from role_r1,rx;
   140  revoke alter view on database *.* from role_r1,rx;
   141  revoke alter view on database d from role_r1,rx;
   142  revoke all on database * from role_r1,rx;
   143  revoke all on database *.* from role_r1,rx;
   144  revoke all on database d from role_r1,rx;
   145  revoke ownership on database * from role_r1,rx;
   146  revoke ownership on database *.* from role_r1,rx;
   147  revoke ownership on database d from role_r1,rx;
   148  revoke select on table * from role_r1,rx;
   149  revoke select on table *.* from role_r1,rx;
   150  revoke select on table d.* from role_r1,rx;
   151  revoke select on table d.t from role_r1,rx;
   152  revoke select on table t from role_r1,rx;
   153  revoke insert on table * from role_r1,rx;
   154  revoke insert on table *.* from role_r1,rx;
   155  revoke insert on table d.* from role_r1,rx;
   156  revoke insert on table d.t from role_r1,rx;
   157  revoke insert on table t from role_r1,rx;
   158  revoke update on table * from role_r1,rx;
   159  revoke update on table *.* from role_r1,rx;
   160  revoke update on table d.* from role_r1,rx;
   161  revoke update on table d.t from role_r1,rx;
   162  revoke update on table t from role_r1,rx;
   163  revoke truncate on table * from role_r1,rx;
   164  revoke truncate on table *.* from role_r1,rx;
   165  revoke truncate on table d.* from role_r1,rx;
   166  revoke truncate on table d.t from role_r1,rx;
   167  revoke truncate on table t from role_r1,rx;
   168  revoke delete on table * from role_r1,rx;
   169  revoke delete on table *.* from role_r1,rx;
   170  revoke delete on table d.* from role_r1,rx;
   171  revoke delete on table d.t from role_r1,rx;
   172  revoke delete on table t from role_r1,rx;
   173  revoke reference on table * from role_r1,rx;
   174  revoke reference on table *.* from role_r1,rx;
   175  revoke reference on table d.* from role_r1,rx;
   176  revoke reference on table d.t from role_r1,rx;
   177  revoke reference on table t from role_r1,rx;
   178  revoke index on table * from role_r1,rx;
   179  revoke index on table *.* from role_r1,rx;
   180  revoke index on table d.* from role_r1,rx;
   181  revoke index on table d.t from role_r1,rx;
   182  revoke index on table t from role_r1,rx;
   183  revoke all on table * from role_r1,rx;
   184  revoke all on table *.* from role_r1,rx;
   185  revoke all on table d.* from role_r1,rx;
   186  revoke all on table d.t from role_r1,rx;
   187  revoke all on table t from role_r1,rx;
   188  revoke ownership on table * from role_r1,rx;
   189  revoke ownership on table *.* from role_r1,rx;
   190  revoke ownership on table d.* from role_r1,rx;
   191  revoke ownership on table d.t from role_r1,rx;
   192  revoke ownership on table t from role_r1,rx;
   193  revoke execute on table * from role_r1,rx;
   194  revoke execute on table *.* from role_r1,rx;
   195  revoke execute on table d.* from role_r1,rx;
   196  revoke execute on table d.t from role_r1,rx;
   197  revoke execute on table t from role_r1,rx;
   198  
   199  drop role role_r1;
   200  drop database if exists d;
   201  set global enable_privilege_cache = on;