github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/zz_accesscontrol/create_account.result (about) 1 drop account if exists `test@123456`; 2 drop account if exists testaccount; 3 drop account if exists 123_acc; 4 drop account if exists _acc; 5 drop account if exists a12; 6 drop account if exists _acc1; 7 drop account if exists FaSt; 8 drop account if exists `123`; 9 drop account if exists a123; 10 drop account if exists `abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff`; 11 drop account if exists abc; 12 drop account if exists abcd; 13 drop account if exists cm1; 14 drop account if exists cm2; 15 drop account if exists cm3; 16 drop account if exists accout_Xingming_insert; 17 drop account if exists `ab.cd`; 18 drop account if exists `test/123`; 19 drop account if exists `test%`; 20 drop account if exists `非常`; 21 drop account if exists user_strip_01; 22 drop account if exists account_1; 23 drop account if exists aaa; 24 drop account if exists account; 25 create account `test@123456` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 26 select account_name from mo_catalog.mo_account where account_name='test@123456'; 27 account_name 28 test@123456 29 create account testaccount ADMIN_NAME 'admin@123' IDENTIFIED BY 'yyyy_1234@126.com'; 30 select account_name from mo_catalog.mo_account where account_name='testaccount'; 31 account_name 32 testaccount 33 create account 123_acc ADMIN_NAME '8888' IDENTIFIED BY 'ffffff'; 34 select account_name from mo_catalog.mo_account where account_name='123_acc'; 35 account_name 36 123_acc 37 create account _acc ADMIN_NAME 'AbcDef' IDENTIFIED BY 'NIU_2345'; 38 select account_name from mo_catalog.mo_account where account_name='_acc'; 39 account_name 40 _acc 41 create account a12 ADMIN_NAME 'a12' IDENTIFIED BY 'aaaaa'; 42 select account_name from mo_catalog.mo_account where account_name='a12'; 43 account_name 44 a12 45 create account _acc1 ADMIN_NAME '_AbcDef' IDENTIFIED BY '_2345'; 46 select account_name from mo_catalog.mo_account where account_name='_acc1'; 47 account_name 48 _acc1 49 create account a123 ADMIN_NAME 'a12' IDENTIFIED BY 'aaaaa'; 50 select account_name from mo_catalog.mo_account where account_name='a12'; 51 account_name 52 a12 53 create account FaSt ADMIN_NAME '账号' IDENTIFIED BY '账号密码'; 54 select account_name from mo_catalog.mo_account where account_name='fast'; 55 account_name 56 fast 57 create account `ab.cd` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 58 select account_name from mo_catalog.mo_account where account_name='ab.cd'; 59 account_name 60 ab.cd 61 create account `test/123` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 62 select account_name from mo_catalog.mo_account where account_name='test/123'; 63 account_name 64 test/123 65 create account `test%` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 66 select account_name from mo_catalog.mo_account where account_name='test%'; 67 account_name 68 test% 69 create account `123` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 70 select account_name from mo_catalog.mo_account where account_name='123'; 71 account_name 72 123 73 create account `非常` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 74 select account_name from mo_catalog.mo_account where account_name='非常'; 75 account_name 76 非常 77 create account `abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff` admin_name `abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffffdddddd` IDENTIFIED BY '1111111111111111111111111111111111111111111111111111111'; 78 select account_name from mo_catalog.mo_account where account_name='abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff'; 79 account_name 80 abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff 81 create account ` user_strip_01 ` ADMIN_NAME " admin " IDENTIFIED BY " 123456 "; 82 select account_name from mo_catalog.mo_account where account_name='user_strip_01'; 83 account_name 84 user_strip_01 85 create account abc ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 86 select account_name from mo_catalog.mo_account where account_name='abc'; 87 account_name 88 abc 89 create account ABC ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 90 internal error: the tenant abc exists 91 create account Abc ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 92 internal error: the tenant abc exists 93 create account IF NOT EXISTS Abc ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 94 create account IF NOT EXISTS Abcd ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment '这是comment备注/123456'; 95 select account_name,comments from mo_catalog.mo_account where account_name='abcd'; 96 account_name comments 97 abcd 这是comment备注/123456 98 create account IF NOT EXISTS cm1 ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment 'this is test comment , please check'; 99 select account_name,comments from mo_catalog.mo_account where account_name='cm1'; 100 account_name comments 101 cm1 this is test comment , please check 102 create account cm2 ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment 'abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff'; 103 select account_name,comments from mo_catalog.mo_account where account_name='cm2'; 104 account_name comments 105 cm2 abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff 106 create account cm3 ADMIN_NAME 'admin' IDENTIFIED BY '123456' comment ''; 107 select account_name,comments from mo_catalog.mo_account where account_name='cm3'; 108 account_name comments 109 cm3 110 create accout a1 ADMIN_NAME ' admin' IDENTIFIED BY '123456'; 111 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 13 near " accout a1 ADMIN_NAME ' admin' IDENTIFIED BY '123456';"; 112 create account a1; 113 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 18 near ";"; 114 create accout a1 ADMIN_NAME ' admin'; 115 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 13 near " accout a1 ADMIN_NAME ' admin';"; 116 create accout a1 IDENTIFIED BY '123456'; 117 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 13 near " accout a1 IDENTIFIED BY '123456';"; 118 create accout a1 comment'aaaa'; 119 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 13 near " accout a1 comment'aaaa';"; 120 create account 123 ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 121 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 18 near " 123 ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 122 create account 非常 ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 123 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 " 非常 ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 124 create account "acc1" ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 125 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 21 near " "acc1" ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 126 create account 'acc1' ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 127 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 21 near " 'acc1' ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 128 create account bbb ADMIN_NAME '' IDENTIFIED BY '123456'; 129 internal error: the name "" is invalid 130 create account `` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 131 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 " `` ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 132 create account aaa ADMIN_NAME 'admin' IDENTIFIED BY ''; 133 internal error: password is empty string 134 create account test:account ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 135 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 27 near ":account ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 136 create account 'test:account' ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 137 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 " 'test:account' ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 138 create account "test:account" ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 139 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 " "test:account" ADMIN_NAME 'admin' IDENTIFIED BY '123456';"; 140 create account `test:account` ADMIN_NAME 'admin' IDENTIFIED BY '123456'; 141 internal error: the name "test:account" is invalid 142 create account default ADMIN_NAME 'root' IDENTIFIED BY '123456'; 143 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 22 near " default ADMIN_NAME 'root' IDENTIFIED BY '123456';"; 144 create account account ADMIN_NAME 'root' IDENTIFIED BY '123456'; 145 select count(*) from mo_catalog.mo_account where account_name in ('test:account','default','account'); 146 count(*) 147 1 148 create account account_1 admin_name='admin' identified by '123456'; 149 show databases; 150 Database 151 mo_catalog 152 system_metrics 153 system 154 information_schema 155 mysql 156 use mo_catalog; 157 show tables; 158 tables_in_mo_catalog 159 mo_columns 160 mo_user 161 mo_role 162 mo_user_grant 163 mo_role_grant 164 mo_role_privs 165 mo_user_defined_function 166 mo_mysql_compatbility_mode 167 mo_tables 168 mo_database 169 select user_name,authentication_string,owner from mo_user; 170 user_name authentication_string owner 171 admin 123456 0 172 select role_name,obj_type,privilege_name,privilege_level from mo_role_privs; 173 role_name obj_type privilege_name privilege_level 174 accountadmin account create user * 175 accountadmin account drop user * 176 accountadmin account alter user * 177 accountadmin account create role * 178 accountadmin account drop role * 179 accountadmin account create database * 180 accountadmin account drop database * 181 accountadmin account show databases * 182 accountadmin account connect * 183 accountadmin account manage grants * 184 accountadmin account account all * 185 accountadmin database show tables * 186 accountadmin database create table * 187 accountadmin database drop table * 188 accountadmin database alter table * 189 accountadmin database create view * 190 accountadmin database drop view * 191 accountadmin database alter view * 192 accountadmin database database all * 193 accountadmin database database ownership * 194 accountadmin table select *.* 195 accountadmin table insert *.* 196 accountadmin table update *.* 197 accountadmin table truncate *.* 198 accountadmin table delete *.* 199 accountadmin table reference *.* 200 accountadmin table index *.* 201 accountadmin table table all *.* 202 accountadmin table table ownership *.* 203 accountadmin table values t 204 public account connect * 205 create database account_1_db; 206 CREATE USER account_1_user IDENTIFIED BY '123456'; 207 create table a(b int); 208 internal error: do not have privilege to execute the statement 209 use account_1_db; 210 create table a(b int); 211 use mo_catalog; 212 select user_name,authentication_string,owner from mo_user where user_name ='account_1_user'; 213 user_name authentication_string owner 214 create account accout_Xingming_insert ADMIN_NAME 'root' IDENTIFIED BY '123456789'; 215 select account_name from mo_catalog.mo_account where account_name='accout_xingming_insert'; 216 account_name 217 accout_xingming_insert 218 drop account accout_Xingming_insert; 219 select account_name from mo_catalog.mo_account where account_name='accout_xingming_insert'; 220 account_name 221 create account if not exists accout_Xingming_insert ADMIN_NAME 'root' IDENTIFIED BY '123456789'; 222 select account_name from mo_catalog.mo_account where account_name='accout_xingming_insert'; 223 account_name 224 accout_xingming_insert 225 drop account if exists `test@123456`; 226 drop account if exists testaccount; 227 drop account if exists 123_acc; 228 drop account if exists _acc; 229 drop account if exists a12; 230 drop account if exists _acc1; 231 drop account if exists FaSt; 232 drop account if exists `123`; 233 drop account if exists a123; 234 drop account if exists `abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff`; 235 drop account if exists abc; 236 drop account if exists abcd; 237 drop account if exists cm1; 238 drop account if exists cm2; 239 drop account if exists cm3; 240 drop account if exists accout_Xingming_insert; 241 drop account if exists `ab.cd`; 242 drop account if exists `test/123`; 243 drop account if exists `test%`; 244 drop account if exists `非常`; 245 drop account if exists user_strip_01; 246 drop account if exists account_1; 247 drop account if exists aaa; 248 drop account if exists account;