github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/tenant/privilege/role2.result (about) 1 create role role_r1,role_r2,role_r3,role_r4,r1,r2; 2 create user role_u1 identified by '111', role_u2 identified by '111'; 3 revoke if exists r1,r2 from u1,u2; 4 revoke if exists r1,r2 from u1,role_u2; 5 revoke if exists r1,r2 from role_u1,u2; 6 revoke if exists r1,r2 from role_u1,role_u2; 7 revoke if exists r1,role_r2 from u1,u2; 8 revoke if exists r1,role_r2 from u1,role_u2; 9 revoke if exists r1,role_r2 from role_u1,u2; 10 revoke if exists r1,role_r2 from role_u1,role_u2; 11 revoke if exists role_r1,r2 from u1,u2; 12 revoke if exists role_r1,r2 from u1,role_u2; 13 revoke if exists role_r1,r2 from role_u1,u2; 14 revoke if exists role_r1,r2 from role_u1,role_u2; 15 revoke if exists role_r1,role_r2 from u1,u2; 16 revoke if exists role_r1,role_r2 from u1,role_u2; 17 revoke if exists role_r1,role_r2 from role_u1,u2; 18 revoke if exists role_r1,role_r2 from role_u1,role_u2; 19 revoke r1,r2 from u1,u2; 20 internal error: there is no role or user u1 21 revoke r1,r2 from u1,role_u2; 22 internal error: there is no role or user u1 23 revoke r1,r2 from role_u1,u2; 24 internal error: there is no role or user u2 25 revoke r1,r2 from role_u1,role_u2; 26 revoke r1,role_r2 from u1,u2; 27 internal error: there is no role or user u1 28 revoke r1,role_r2 from u1,role_u2; 29 internal error: there is no role or user u1 30 revoke r1,role_r2 from role_u1,u2; 31 internal error: there is no role or user u2 32 revoke r1,role_r2 from role_u1,role_u2; 33 revoke role_r1,r2 from u1,u2; 34 internal error: there is no role or user u1 35 revoke role_r1,r2 from u1,role_u2; 36 internal error: there is no role or user u1 37 revoke role_r1,r2 from role_u1,u2; 38 internal error: there is no role or user u2 39 revoke role_r1,r2 from role_u1,role_u2; 40 revoke role_r1,role_r2 from u1,u2; 41 internal error: there is no role or user u1 42 revoke role_r1,role_r2 from u1,role_u2; 43 internal error: there is no role or user u1 44 revoke role_r1,role_r2 from role_u1,u2; 45 internal error: there is no role or user u2 46 revoke role_r1,role_r2 from role_u1,role_u2; 47 drop role role_r1,role_r2,role_r3,role_r4,r1,r2; 48 drop user role_u1,role_u2;