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

     1  set global enable_privilege_cache = off;
     2  create role role_r1,role_r2,role_r3,role_r4,r1,r2;
     3  create user role_u1 identified by '111', role_u2 identified by '111';
     4  
     5  revoke if exists r1,r2 from u1,u2;
     6  revoke if exists r1,r2 from u1,role_u2;
     7  revoke if exists r1,r2 from role_u1,u2;
     8  revoke if exists r1,r2 from role_u1,role_u2;
     9  revoke if exists r1,role_r2 from u1,u2;
    10  revoke if exists r1,role_r2 from u1,role_u2;
    11  revoke if exists r1,role_r2 from role_u1,u2;
    12  revoke if exists r1,role_r2 from role_u1,role_u2;
    13  revoke if exists role_r1,r2 from u1,u2;
    14  revoke if exists role_r1,r2 from u1,role_u2;
    15  revoke if exists role_r1,r2 from role_u1,u2;
    16  revoke if exists role_r1,r2 from role_u1,role_u2;
    17  revoke if exists role_r1,role_r2 from u1,u2;
    18  revoke if exists role_r1,role_r2 from u1,role_u2;
    19  revoke if exists role_r1,role_r2 from role_u1,u2;
    20  revoke if exists role_r1,role_r2 from role_u1,role_u2;
    21  revoke r1,r2 from u1,u2;
    22  revoke r1,r2 from u1,role_u2;
    23  revoke r1,r2 from role_u1,u2;
    24  revoke r1,r2 from role_u1,role_u2;
    25  revoke r1,role_r2 from u1,u2;
    26  revoke r1,role_r2 from u1,role_u2;
    27  revoke r1,role_r2 from role_u1,u2;
    28  revoke r1,role_r2 from role_u1,role_u2;
    29  revoke role_r1,r2 from u1,u2;
    30  revoke role_r1,r2 from u1,role_u2;
    31  revoke role_r1,r2 from role_u1,u2;
    32  revoke role_r1,r2 from role_u1,role_u2;
    33  revoke role_r1,role_r2 from u1,u2;
    34  revoke role_r1,role_r2 from u1,role_u2;
    35  revoke role_r1,role_r2 from role_u1,u2;
    36  revoke role_r1,role_r2 from role_u1,role_u2;
    37  
    38  drop role role_r1,role_r2,role_r3,role_r4,r1,r2;
    39  drop user role_u1,role_u2;
    40  set global enable_privilege_cache = on;