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

     1  drop role if exists drop_role1,drop_role2,drop_role3,drop_role4,drop_role5,drop_role6,drop_role7,drop_role8,drop_role9,drop_role10;
     2  drop role if exists drop_role_001,drop_role_002,drop_role_1,drop_role_2;
     3  drop user if exists drop_user_1,drop_user_2;
     4  create role drop_role_001;
     5  drop role drop_role_001;
     6  select role_name from mo_catalog.mo_role where role_name='drop_role_001';
     7  role_name
     8  drop role role_name;
     9  internal error: there is no role role_name
    10  drop role if exists drop_role_002;
    11  create role drop_role_002;
    12  drop role if exists drop_role_002;
    13  select role_name from mo_catalog.mo_role where role_name='drop_role_002';
    14  role_name
    15  drop role '';
    16  internal error: the name "" is invalid
    17  drop role moadmin;
    18  internal error: can not delete the role moadmin
    19  drop role public;
    20  internal error: can not delete the role public
    21  drop if not exists d;
    22  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;";
    23  drop role if not exists d;
    24  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;";
    25  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;
    26  drop role drop_role1,drop_role2,drop_role3,drop_role11;
    27  internal error: there is no role drop_role11
    28  drop role if exists drop_role1,drop_role2,drop_role3,drop_role11;
    29  drop role if exists drop_role4,drop_role5,drop_role6,root,drop_role8;
    30  drop role if exists drop_role9,drop_role10;
    31  select role_name from mo_catalog.mo_role where role_name like 'drop_role%';
    32  role_name
    33  drop_role7
    34  create role drop_role_1,drop_role_2;
    35  create user drop_user_1 identified by '111',drop_user_2 identified by '111';
    36  grant all on table *.* to drop_role_1 with grant option;
    37  grant drop_role_1 to drop_user_1;
    38  grant drop_role_2 to drop_user_2;
    39  select role_name from mo_catalog.mo_role where role_name in ('drop_role_1','drop_role_2');
    40  role_name
    41  drop_role_1
    42  drop_role_2
    43  grant drop_role_1 to drop_role_2;
    44  drop role drop_role_1;
    45  select role_name from mo_catalog.mo_role where role_name in ('drop_role_1','drop_role_2');
    46  role_name
    47  drop_role_2
    48  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');
    49  role_name
    50  drop_role_2
    51  drop role if exists drop_role1,drop_role2,drop_role3,drop_role4,drop_role5,drop_role6,drop_role7,drop_role8,drop_role9,drop_role10;
    52  drop role if exists drop_role_001,drop_role_002,drop_role_1,drop_role_2;
    53  drop user if exists drop_user_1,drop_user_2;