github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/zz_accesscontrol/drop_role.result (about)

     1  set global enable_privilege_cache = off;
     2  drop role if exists drop_role1,drop_role2,drop_role3,drop_role4,drop_role5,drop_role6,drop_role7,drop_role8,drop_role9,drop_role10;
     3  drop role if exists drop_role_001,drop_role_002,drop_role_1,drop_role_2;
     4  drop user if exists drop_user_1,drop_user_2;
     5  create role drop_role_001;
     6  drop role drop_role_001;
     7  select role_name from mo_catalog.mo_role where role_name='drop_role_001';
     8  role_name
     9  drop role role_name;
    10  internal error: there is no role role_name
    11  drop role if exists drop_role_002;
    12  create role drop_role_002;
    13  drop role if exists drop_role_002;
    14  select role_name from mo_catalog.mo_role where role_name='drop_role_002';
    15  role_name
    16  drop role '';
    17  internal error: the name "" is invalid
    18  drop role moadmin;
    19  internal error: can not delete the role moadmin
    20  drop role public;
    21  internal error: can not delete the role public
    22  drop if not exists d;
    23  SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 7 near " if not exists d;";
    24  drop role if not exists d;
    25  SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 16 near " not exists d;";
    26  create role if not exists drop_role1,drop_role2,drop_role3,drop_role4,drop_role5,drop_role6,drop_role7,drop_role8,drop_role9,drop_role10;
    27  drop role drop_role1,drop_role2,drop_role3,drop_role11;
    28  internal error: there is no role drop_role11
    29  drop role if exists drop_role1,drop_role2,drop_role3,drop_role11;
    30  drop role if exists drop_role4,drop_role5,drop_role6,root,drop_role8;
    31  drop role if exists drop_role9,drop_role10;
    32  select role_name from mo_catalog.mo_role where role_name like 'drop_role%';
    33  role_name
    34  drop_role7
    35  create role drop_role_1,drop_role_2;
    36  create user drop_user_1 identified by '111',drop_user_2 identified by '111';
    37  grant all on table *.* to drop_role_1 with grant option;
    38  grant drop_role_1 to drop_user_1;
    39  grant drop_role_2 to drop_user_2;
    40  select role_name from mo_catalog.mo_role where role_name in ('drop_role_1','drop_role_2');
    41  role_name
    42  drop_role_1
    43  drop_role_2
    44  grant drop_role_1 to drop_role_2;
    45  drop role drop_role_1;
    46  select role_name from mo_catalog.mo_role where role_name in ('drop_role_1','drop_role_2');
    47  role_name
    48  drop_role_2
    49  select role_name from mo_catalog.mo_user_grant mug ,mo_catalog.mo_role mr where mug.role_id=mr.role_id and mr.role_name in ('drop_role_1','drop_role_2');
    50  role_name
    51  drop_role_2
    52  drop role if exists drop_role1,drop_role2,drop_role3,drop_role4,drop_role5,drop_role6,drop_role7,drop_role8,drop_role9,drop_role10;
    53  drop role if exists drop_role_001,drop_role_002,drop_role_1,drop_role_2;
    54  drop user if exists drop_user_1,drop_user_2;
    55  set global enable_privilege_cache = on;