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

     1  drop user if exists yellowcar,test_user,user123456,123user,`1234@fff`,`1234`,`user1234.aaaa`,`123user中文`,user_role,user123456,c_user_01,c_user_02,c_user_03,customername,customer,custom,finley,jason,`neil@192.168.1.10`;
     2  drop user if exists test_user,test_user0,test_user1,test_user2,user1,user2,user3,user4,user5,user6,user7,user8,user9,user10,tester1,tester2,tester001,tester002,tester003,`daisy@192.168.1.10`,daisy;
     3  drop user if exists user1,tester1,tester2,jason,finley,custom,customer,customname,c_user_01,c_user_02,c_user_03;
     4  drop account if exists test5555;
     5  drop role if exists low_level,mid_level,high_level,u_role;
     6  drop table if exists testdb.aaa;
     7  create role if not exists u_role;
     8  create user yellowcar identified by 'oldmaster';
     9  select user_name,authentication_string from mo_catalog.mo_user where user_name='yellowcar';
    10  user_name    authentication_string
    11  yellowcar    oldmaster
    12  create user  user123456 identified by 'TYUJI_123@126.cn' comment '这是创建用户测试aaaa11111';
    13  select user_name,authentication_string from mo_catalog.mo_user where user_name='user123456';
    14  user_name    authentication_string
    15  user123456    TYUJI_123@126.cn
    16  create user  123user  identified by 'eeeeee' ;
    17  select user_name, authentication_string from mo_catalog.mo_user where user_name='123user';
    18  user_name    authentication_string
    19  123user    eeeeee
    20  create user Test_user identified by '12345678';
    21  create user Test_User identified by '12345678';
    22  internal error: the user test_user exists
    23  create user `1234@fff` identified by '#¥%……&' comment 'this is test@fefffff' ;
    24  select user_name, authentication_string from mo_catalog.mo_user where user_name='1234@fff';
    25  user_name    authentication_string
    26  1234@fff    #¥%……&
    27  create user  `1234`  identified by '#¥%……&' comment 'this is test@fefffff' ;
    28  select user_name, authentication_string from mo_catalog.mo_user where user_name='1234';
    29  user_name    authentication_string
    30  1234    #¥%……&
    31  create user `user1234.aaaa`  identified by '#¥%……&' comment 'this is test@fefffff' ;
    32  select user_name, authentication_string from mo_catalog.mo_user where user_name='user1234.aaaa';
    33  user_name    authentication_string
    34  user1234.aaaa    #¥%……&
    35  create user  `123user中文`  identified by 'eee中文' ;
    36  select user_name, authentication_string from mo_catalog.mo_user where user_name='123user中文';
    37  user_name    authentication_string
    38  123user中文    eee中文
    39  create user  "test_user0" identified by '12345678';
    40  create user  ` c_user_01 `  identified by ' 1111 ' ;
    41  create user  " c_user_02 "  identified by '1111' ;
    42  create user  ' c_user_03 '  identified by '1111' ;
    43  select user_name, authentication_string from mo_catalog.mo_user where user_name in('c_user_01','c_user_02','c_user_03');
    44  user_name    authentication_string
    45  c_user_01     1111 
    46  c_user_02    1111
    47  c_user_03    1111
    48  create user if not exists test_user1 identified by '12345678';
    49  create user  test_user1 identified by '12345678';
    50  internal error: the user test_user1 exists
    51  create user if not exists test_user1 identified by '12345678';
    52  create user user1 identified by '12345678',user2 identified by '12345678',user3 identified by '12345678',user4 identified by '12345678',user5 identified by '12345678',user6 identified by '12345678',user7 identified by '12345678',user8 identified by '12345678',user9 identified by '12345678',user10 identified by '12345678' default role u_role;
    53  select count(*) from mo_catalog.mo_user where user_name like 'user%';
    54  count(*)
    55  24
    56  create user tester1 identified by '12345678',tester2 identified by '12345678',user3 identified by '12345678',user4 identified by '12345678';
    57  internal error: the user user3 exists
    58  select count(*) from mo_catalog.mo_user where user_name like 'tester%';
    59  count(*)
    60  0
    61  create user if not exists tester1 identified by '12345678',tester2 identified by '12345678',user3 identified by '12345678',user4 identified by '12345678';
    62  select count(*) from mo_catalog.mo_user where user_name like 'tester%';
    63  count(*)
    64  2
    65  create user tester001 identified by '12345678',tester002  identified by '12345678',tester:003 identified by '12345678';
    66  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 90 near ":003 identified by '12345678';";
    67  create user if not exists tester001 identified by '12345678',tester002  identified by '12345678',tester:003 identified by '12345678';
    68  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 104 near ":003 identified by '12345678';";
    69  select count(*) from mo_catalog.mo_user where user_name like 'tester00%';
    70  count(*)
    71  0
    72  CREATE USER daisy@192.168.1.10 IDENTIFIED BY '123456';
    73  select user_name, user_host from mo_catalog.mo_user where user_name='daisy';
    74  user_name    user_host
    75  daisy    192.168.1.10
    76  CREATE USER 'neil@192.168.1.10' IDENTIFIED BY '123456';
    77  select user_name, user_host from mo_catalog.mo_user where user_name='neil';
    78  user_name    user_host
    79  CREATE USER 'jason'@'192.168.1.10' IDENTIFIED BY '123456';
    80  select user_name, user_host from mo_catalog.mo_user where user_name='jason';
    81  user_name    user_host
    82  jason    192.168.1.10
    83  create user 'finley'@'%.example.com' IDENTIFIED BY '123456';
    84  select user_name, user_host from mo_catalog.mo_user where user_name='finley';
    85  user_name    user_host
    86  finley    %.example.com
    87  CREATE USER 'custom'@'localhost' IDENTIFIED BY '11111';
    88  select user_name, user_host from mo_catalog.mo_user where user_name='custom';
    89  user_name    user_host
    90  custom    localhost
    91  CREATE USER 'customer'@'host47.example.com' IDENTIFIED BY '1111';
    92  select user_name, user_host from mo_catalog.mo_user where user_name='customer';
    93  user_name    user_host
    94  customer    host47.example.com
    95  CREATE USER 'customername'@'%' IDENTIFIED BY '1111';
    96  select user_name, user_host from mo_catalog.mo_user where user_name='customername';
    97  user_name    user_host
    98  customername    localhost
    99  CREATE USER ''@'localhost' IDENTIFIED BY '1111';
   100  internal error: the name "" is invalid
   101  create user if not exists user1 ,user2 ,user3 identified by '12345678';
   102  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 33 near " ,user2 ,user3 identified by '12345678';";
   103  create user if not exists all identified by '111' ;
   104  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 29 near " all identified by '111' ;";
   105  create user user:1 identified by '111' ;
   106  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 17 near ":1 identified by '111' ;";
   107  create user 'user:1' identified by '111' ;
   108  internal error: the name "user:1" is invalid
   109  create user "user:1" identified by '111' ;
   110  internal error: the name "user:1" is invalid
   111  create user `user:1` identified by '111' ;
   112  internal error: the name "user:1" is invalid
   113  create user user_aaa identified by '12345678' default role aaa ;
   114  internal error: there is no role aaa
   115  create user '' identified by '111' ;
   116  internal error: the name "" is invalid
   117  create user c_user_4 identified by '' ;
   118  internal error: password is empty string
   119  create user if not exists test_user2 identified by '12345678';
   120  select user_name,authentication_string from mo_catalog.mo_user where user_name='test_user2';
   121  user_name    authentication_string
   122  test_user2    12345678
   123  drop user test_user2;
   124  select user_name,authentication_string from mo_catalog.mo_user where user_name='test_user2';
   125  user_name    authentication_string
   126  create user if not exists test_user2 identified by '12345678';
   127  select user_name,authentication_string from mo_catalog.mo_user where user_name='test_user2';
   128  user_name    authentication_string
   129  test_user2    12345678
   130  create user if not exists user1 identified by '12345678' default role moadmin;
   131  internal error: the role moadmin can not be granted to non administration user user1
   132  drop user if exists yellowcar,test_user,user123456,123user,`1234@fff`,`1234`,`user1234.aaaa`,`123user中文`,user_role,user123456,c_user_01,c_user_02,c_user_03,customername,customer,custom,finley,jason,`neil@192.168.1.10`;
   133  drop user if exists test_user,test_user0,test_user1,test_user2,user1,user2,user3,user4,user5,user6,user7,user8,user9,user10,tester1,tester2,tester001,tester002,tester003,`daisy@192.168.1.10`,daisy;
   134  drop user if exists user1,tester1,tester2,jason,finley,custom,customer,customname,c_user_01,c_user_02,c_user_03;
   135  drop account if exists test5555;
   136  drop role if exists low_level,mid_level,high_level,u_role;
   137  drop table if exists testdb.aaa;