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

     1  create account if not exists Abc ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment 'comment test';
     2  alter account abc admin_name='admin'  IDENTIFIED BY '1WERDFT3YG';
     3  select user_name,authentication_string from mo_catalog.mo_user;
     4  user_name    authentication_string
     5  admin    1WERDFT3YG
     6  create database testdb;
     7  drop database testdb;
     8  alter account abc admin_name='admin'  IDENTIFIED BY 'yyyy_34lifel';
     9  select user_name,authentication_string from mo_catalog.mo_user;
    10  user_name    authentication_string
    11  admin    yyyy_34lifel
    12  alter account abc admin_name='admin'  IDENTIFIED BY 'abcddddddfsfafaffsefsfsefljofiseosfjosissssssssssssssssssssssssssssssssssssssssssssssssssssssssssss';
    13  select user_name,authentication_string from mo_catalog.mo_user;
    14  user_name    authentication_string
    15  admin    abcddddddfsfafaffsefsfsefljofiseosfjosissssssssssssssssssssssssssssssssssssssssssssssssssssssssssss
    16  show databases;
    17  Database
    18  mo_catalog
    19  system
    20  system_metrics
    21  information_schema
    22  mysql
    23  alter account abc admin_name='admin'  IDENTIFIED BY 'Ni7893';
    24  select user_name,authentication_string from mo_catalog.mo_user;
    25  user_name    authentication_string
    26  admin    Ni7893
    27  alter account abc admin_name='admin'  IDENTIFIED BY '_1234';
    28  select user_name,authentication_string from mo_catalog.mo_user;
    29  user_name    authentication_string
    30  admin    _1234
    31  alter account abc admin_name='admin'  IDENTIFIED BY 'nnnn@12.fef';
    32  select user_name,authentication_string from mo_catalog.mo_user;
    33  user_name    authentication_string
    34  admin    nnnn@12.fef
    35  alter account abc admin_name='admin'  IDENTIFIED BY '密码';
    36  select user_name,authentication_string from mo_catalog.mo_user;
    37  user_name    authentication_string
    38  admin    密码
    39  alter account abc admin_name='admin'  IDENTIFIED BY '123 456';
    40  select user_name,authentication_string from mo_catalog.mo_user;
    41  user_name    authentication_string
    42  admin    123 456
    43  alter account abc admin_name='admin'  IDENTIFIED BY 'test:aaa';
    44  select user_name,authentication_string from mo_catalog.mo_user;
    45  user_name    authentication_string
    46  admin    test:aaa
    47  drop account abc;
    48  create account if not exists test ADMIN_NAME '1WERDFT3YG' IDENTIFIED BY '123456';
    49  alter account test admin_name='1WERDFT3YG'  IDENTIFIED BY '';
    50  internal error: password is empty string
    51  alter account not_exist_account ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    52  internal error: there is no account not_exist_account
    53  alter account if exists not_exist_account ADMIN_NAME 'admin' IDENTIFIED BY '123456';
    54  alter account test ADMIN_NAME 'testaaa' IDENTIFIED BY '123456';
    55  internal error: there is no user testaaa
    56  alter account if exists test ADMIN_NAME 'testaaa' IDENTIFIED BY '123456';
    57  internal error: there is no user testaaa
    58  drop account test;
    59  create account if not exists test ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment 'account comment';
    60  alter account test admin_name='admin'  IDENTIFIED BY '123456';
    61  select user_name,authentication_string from mo_catalog.mo_user;
    62  user_name    authentication_string
    63  admin    123456
    64  drop account test;
    65  create account if not exists alaccount ADMIN_NAME 'WERTY12ERT' IDENTIFIED BY '123456' comment 'account comment';
    66  create user 'al_user_1' identified by '123456';
    67  create role if not exists al_role;
    68  grant all on account * to al_role;
    69  grant al_role to al_user_1;
    70  create database al_db;
    71  alter account alaccount ADMIN_NAME 'WERTY12ERT' IDENTIFIED BY 'abc@123';
    72  select user_name,authentication_string from mo_catalog.mo_user where user_name='al_user_1';
    73  user_name    authentication_string
    74  al_user_1    123456
    75  select role_name,comments from mo_catalog.mo_role;
    76  role_name    comments
    77  accountadmin    
    78  public    
    79  al_role    
    80  show databases;
    81  Database
    82  system
    83  system_metrics
    84  information_schema
    85  mysql
    86  al_db
    87  mo_catalog
    88  drop database al_db;
    89  drop account alaccount;
    90  create account if not exists testcomment ADMIN_NAME 'test_user' IDENTIFIED BY 'Asd1235' comment 'account comment';
    91  alter account testcomment comment 'new account comment';
    92  select account_name,comments from mo_catalog.mo_account where account_name='testcomment';
    93  account_name    comments
    94  testcomment    new account comment
    95  show databases;
    96  Database
    97  system
    98  system_metrics
    99  information_schema
   100  mo_catalog
   101  mysql
   102  alter account testcomment comment '';
   103  select account_name,comments from mo_catalog.mo_account where account_name='testcomment';
   104  account_name    comments
   105  testcomment    
   106  alter account testcomment comment 'abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff';
   107  select account_name,comments from mo_catalog.mo_account where account_name='testcomment';
   108  account_name    comments
   109  testcomment    abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff
   110  alter account testcomment comment '周三下午18：00';
   111  select account_name,comments from mo_catalog.mo_account where account_name='testcomment';
   112  account_name    comments
   113  testcomment    周三下午18：00
   114  alter account if exists testcomment comment '177634853$%^&*!@()';
   115  select account_name,comments from mo_catalog.mo_account where account_name='testcomment';
   116  account_name    comments
   117  testcomment    177634853$%^&*!@()
   118  alter account if exists testcomment1 comment '177634853$%^&*!@()';
   119  alter account testcomment1 comment '177634853$%^&*!@()';
   120  internal error: there is no account testcomment1
   121  drop account testcomment;
   122  create account if not exists testsuspend ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment 'account comment';
   123  select user_name, authentication_string from mo_catalog.mo_user;
   124  user_name    authentication_string
   125  admin    123456
   126  alter account testsuspend suspend;
   127  select account_name,status from mo_catalog.mo_account order by account_name;
   128  account_name    status
   129  sys    open
   130  testsuspend    suspend
   131  alter account testsuspend OPEN;
   132  select account_name,status from mo_catalog.mo_account order by account_name;
   133  account_name    status
   134  sys    open
   135  testsuspend    open
   136  alter account testsuspend suspend;
   137  select account_name,status from mo_catalog.mo_account order by account_name;
   138  account_name    status
   139  sys    open
   140  testsuspend    suspend
   141  alter account testsuspend ADMIN_NAME 'admin' IDENTIFIED BY '1234567890';
   142  alter account testsuspend comment 'aaaaaaa';
   143  select account_name,status,comments from mo_catalog.mo_account where account_name='testsuspend';
   144  account_name    status    comments
   145  testsuspend    suspend    aaaaaaa
   146  drop account testsuspend;
   147  select account_name,status from mo_catalog.mo_account where account_name='testsuspend';
   148  account_name    status
   149  alter account testsuspend open;
   150  internal error: there is no account testsuspend
   151  create account if not exists testsuspend ADMIN_NAME 'user01' IDENTIFIED BY 'fffff' comment 'account comment';
   152  alter account testsuspend OPEN;
   153  select account_name,status from mo_catalog.mo_account where account_name='testsuspend';
   154  account_name    status
   155  testsuspend    open
   156  alter account testsuspend OPEN;
   157  select account_name,status from mo_catalog.mo_account where account_name='testsuspend';
   158  account_name    status
   159  testsuspend    open
   160  alter account testsuspend suspend;
   161  select account_name,status from mo_catalog.mo_account where account_name='testsuspend';
   162  account_name    status
   163  testsuspend    suspend
   164  alter account testsuspend suspend;
   165  select account_name,status from mo_catalog.mo_account where account_name='testsuspend';
   166  account_name    status
   167  testsuspend    suspend
   168  drop account testsuspend;
   169  select account_name,status from mo_catalog.mo_account where account_name='testsuspend';
   170  account_name    status
   171  create account if not exists test ADMIN_NAME 'adminuser' IDENTIFIED BY '123456' comment 'account comment';
   172  alter account test admin_name='adminuser'  IDENTIFIED BY '123456' comment 'new comment ' ;
   173  internal error: at most one option at a time
   174  alter account test admin_name='adminuser'  IDENTIFIED BY '123456' suspend comment 'new comment';
   175  internal error: at most one option at a time
   176  alter account test suspend comment 'new comment';
   177  internal error: at most one option at a time
   178  alter account test admin_name='adminuser';
   179  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 42 near ";";
   180  drop account test;
   181  drop user if exists al_user_2;
   182  create user 'al_user_2' identified by '123456';
   183  create role if not exists al_role2;
   184  grant all on account * to al_role2;
   185  grant al_role2 to al_user_2;
   186  create account if not exists test ADMIN_NAME '123ERTYU' IDENTIFIED BY '123ERTYU' comment 'account comment';
   187  alter account test admin_name='adminuser'  IDENTIFIED BY '123456';
   188  internal error: do not have privilege to execute the statement
   189  alter account test comment 'ccccccc';
   190  internal error: do not have privilege to execute the statement
   191  alter account test suspend;
   192  internal error: do not have privilege to execute the statement
   193  drop role if exists al_role2;
   194  drop user if exists al_user_2;
   195  drop account test;