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

     1  -- env prepare statement
     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  
     6  -- 1.drop role存在/不存在
     7  create role drop_role_001;
     8  drop role drop_role_001;
     9  select role_name from mo_catalog.mo_role where role_name='drop_role_001';
    10  drop role role_name;
    11  
    12  --2.drop if exists存在/不存在
    13  drop role if exists drop_role_002;
    14  create role drop_role_002;
    15  drop role if exists drop_role_002;
    16  select role_name from mo_catalog.mo_role where role_name='drop_role_002';
    17  
    18  --3.异常测试：空值，内置role，语法错误
    19  drop role '';
    20  drop role moadmin;
    21  drop role public;
    22  drop if not exists d;
    23  drop role if not exists d;
    24  
    25  --4.一次删除多个role情况，覆盖多个role中有不存在role，无权限删除role
    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  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  
    33  --5.role with grant option 后drop role
    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  grant drop_role_1 to drop_role_2;
    41  drop role drop_role_1;
    42  select role_name from mo_catalog.mo_role where role_name in ('drop_role_1','drop_role_2');
    43  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');
    44  
    45  drop role if exists drop_role1,drop_role2,drop_role3,drop_role4,drop_role5,drop_role6,drop_role7,drop_role8,drop_role9,drop_role10;
    46  drop role if exists drop_role_001,drop_role_002,drop_role_1,drop_role_2;
    47  drop user if exists drop_user_1,drop_user_2;