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