github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/role2.result (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  revoke if exists r1,r2 from u1,u2;
     5  revoke if exists r1,r2 from u1,role_u2;
     6  revoke if exists r1,r2 from role_u1,u2;
     7  revoke if exists r1,r2 from role_u1,role_u2;
     8  revoke if exists r1,role_r2 from u1,u2;
     9  revoke if exists r1,role_r2 from u1,role_u2;
    10  revoke if exists r1,role_r2 from role_u1,u2;
    11  revoke if exists r1,role_r2 from role_u1,role_u2;
    12  revoke if exists role_r1,r2 from u1,u2;
    13  revoke if exists role_r1,r2 from u1,role_u2;
    14  revoke if exists role_r1,r2 from role_u1,u2;
    15  revoke if exists role_r1,r2 from role_u1,role_u2;
    16  revoke if exists role_r1,role_r2 from u1,u2;
    17  revoke if exists role_r1,role_r2 from u1,role_u2;
    18  revoke if exists role_r1,role_r2 from role_u1,u2;
    19  revoke if exists role_r1,role_r2 from role_u1,role_u2;
    20  revoke r1,r2 from u1,u2;
    21  internal error: there is no role or user u1
    22  revoke r1,r2 from u1,role_u2;
    23  internal error: there is no role or user u1
    24  revoke r1,r2 from role_u1,u2;
    25  internal error: there is no role or user u2
    26  revoke r1,r2 from role_u1,role_u2;
    27  revoke r1,role_r2 from u1,u2;
    28  internal error: there is no role or user u1
    29  revoke r1,role_r2 from u1,role_u2;
    30  internal error: there is no role or user u1
    31  revoke r1,role_r2 from role_u1,u2;
    32  internal error: there is no role or user u2
    33  revoke r1,role_r2 from role_u1,role_u2;
    34  revoke role_r1,r2 from u1,u2;
    35  internal error: there is no role or user u1
    36  revoke role_r1,r2 from u1,role_u2;
    37  internal error: there is no role or user u1
    38  revoke role_r1,r2 from role_u1,u2;
    39  internal error: there is no role or user u2
    40  revoke role_r1,r2 from role_u1,role_u2;
    41  revoke role_r1,role_r2 from u1,u2;
    42  internal error: there is no role or user u1
    43  revoke role_r1,role_r2 from u1,role_u2;
    44  internal error: there is no role or user u1
    45  revoke role_r1,role_r2 from role_u1,u2;
    46  internal error: there is no role or user u2
    47  revoke role_r1,role_r2 from role_u1,role_u2;
    48  drop role role_r1,role_r2,role_r3,role_r4,r1,r2;
    49  drop user role_u1,role_u2;
    50  set global enable_privilege_cache = on;