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

     1  drop user if exists drop_user_1,drop_user_2,drop_user_3,drop_user_4,drop_user_5,drop_user_6,drop_user_7,drop_user_8,drop_user_9,drop_user_10,drop_user_11;
     2  drop user if exists drop_user_111,drop_user_112;
     3  drop role if exists drop_u_role_1,drop_u_role_2;
     4  create user drop_user_1 identified by '111';
     5  drop user drop_user_1;
     6  select user_name,authentication_string from mo_catalog.mo_user where user_name='drop_user_1';
     7  user_name    authentication_string
     8  drop user drop_user_1;
     9  internal error: there is no user drop_user_1
    10  drop user if exists drop_user_2;
    11  create user drop_user_2 identified by '111' comment '';
    12  select user_name,authentication_string from mo_catalog.mo_user where user_name='drop_user_2';
    13  user_name    authentication_string
    14  drop_user_2    111
    15  drop user if exists drop_user_2;
    16  select user_name,authentication_string from mo_catalog.mo_user where user_name='drop_user_2';
    17  user_name    authentication_string
    18  drop user "";
    19  internal error: the name "" is invalid
    20  drop user root;
    21  internal error: can not delete the user root
    22  drop user dump;
    23  internal error: can not delete the user dump
    24  drop 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 7 near " if not exists d;";
    26  drop user if not exists d;
    27  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;";
    28  create user drop_user_3 identified by '12345678',drop_user_4 identified by '12345678',drop_user_5 identified by '12345678',drop_user_6 identified by '12345678',drop_user_7 identified by '12345678',drop_user_8 identified by '12345678',drop_user_9 identified by '12345678',drop_user_10 identified by '12345678';
    29  select user_name,authentication_string from mo_catalog.mo_user where user_name like 'drop_user_%';
    30  user_name    authentication_string
    31  drop_user_3    12345678
    32  drop_user_4    12345678
    33  drop_user_5    12345678
    34  drop_user_6    12345678
    35  drop_user_7    12345678
    36  drop_user_8    12345678
    37  drop_user_9    12345678
    38  drop_user_10    12345678
    39  drop user drop_user_3,drop_user_4,drop_user_5;
    40  select user_name,authentication_string from mo_catalog.mo_user where user_name like 'drop_user_%';
    41  user_name    authentication_string
    42  drop_user_6    12345678
    43  drop_user_7    12345678
    44  drop_user_8    12345678
    45  drop_user_9    12345678
    46  drop_user_10    12345678
    47  drop user drop_user_3,drop_user_4,drop_user_5,drop_user_6,drop_user_7;
    48  internal error: there is no user drop_user_3
    49  select user_name,authentication_string from mo_catalog.mo_user where user_name like 'drop_user_%';
    50  user_name    authentication_string
    51  drop_user_6    12345678
    52  drop_user_7    12345678
    53  drop_user_8    12345678
    54  drop_user_9    12345678
    55  drop_user_10    12345678
    56  drop user if exists drop_user_3,drop_user_4,drop_user_5,drop_user_6,drop_user_7;
    57  select user_name,authentication_string from mo_catalog.mo_user where user_name like 'drop_user_%';
    58  user_name    authentication_string
    59  drop_user_8    12345678
    60  drop_user_9    12345678
    61  drop_user_10    12345678
    62  drop user if exists drop_user_8;
    63  select user_name,authentication_string from mo_catalog.mo_user where user_name in ('drop_user_8');
    64  user_name    authentication_string
    65  drop user drop_user_8,drop_user_user;
    66  internal error: there is no user drop_user_8
    67  create role drop_u_role_1,drop_u_role_2;
    68  create user drop_user_111 identified by '111',drop_user_112 identified by '111';
    69  grant all on table *.* to drop_u_role_1 with grant option;
    70  grant drop_u_role_1 to drop_user_111 with grant option;
    71  grant drop_u_role_2 to drop_user_112;
    72  select role_name from mo_catalog.mo_role where role_name in ('drop_u_role_1','drop_u_role_2');
    73  role_name
    74  drop_u_role_1
    75  drop_u_role_2
    76  grant drop_u_role_1 to drop_u_role_2;
    77  drop user drop_user_111;
    78  select user_name,authentication_string from mo_catalog.mo_user where  user_name='drop_user_111';
    79  user_name    authentication_string
    80  select role_name from mo_catalog.mo_role where role_name ='drop_u_role_1';
    81  role_name
    82  drop_u_role_1
    83  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_u_role_1','drop_u_role_2');
    84  role_name
    85  drop_u_role_2
    86  drop user if exists drop_user_1,drop_user_2,drop_user_3,drop_user_4,drop_user_5,drop_user_6,drop_user_7,drop_user_8,drop_user_9,drop_user_10,drop_user_11;
    87  drop user if exists drop_user_111,drop_user_112;
    88  drop role if exists drop_u_role_1,drop_u_role_2;