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

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