github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/zz_accesscontrol/create_role.result (about) 1 drop role if exists newrole, role_1234,12role,`role@hhhh123`,`role.123`,_newrole,role222; 2 drop role if exists role1,role2,role3,role4,role5,role6,role_7,user_role,u_role; 3 drop role if exists role_1,role_2,role_3,role_4,role_5,role_6,role_7,'中文','12345','default';; 4 drop role if exists `abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff`; 5 drop user if exists role_user,user_role; 6 drop role if exists role_role1,role_role2,role_role3,role_role4,role_role5,role_role6,role_role7,role_role8,u_role; 7 drop database if exists p_db; 8 create role newrole, role_1234,12role,`role@hhhh123`,`role.123`,_newrole,RoLe222; 9 create role NewRole; 10 internal error: the role newrole exists 11 select role_name from mo_catalog.mo_role where role_name in ('newrole', 'role_1234','12role','role@hhhh123','role.123','_newrole','role222'); 12 role_name 13 newrole 14 role_1234 15 12role 16 role@hhhh123 17 role.123 18 _newrole 19 role222 20 create role "role_1",'role_2',`role_3`; 21 select role_name from mo_catalog.mo_role where role_name in ('role_1','role_2','role_3'); 22 role_name 23 role_1 24 role_2 25 role_3 26 create role " role_4 ",' role_5 ',` role_6 `; 27 select role_name from mo_catalog.mo_role where role_name in ('role_4','role_5','role_6'); 28 role_name 29 role_4 30 role_5 31 role_6 32 create role '中文','12345'; 33 select role_name from mo_catalog.mo_role where role_name in ('中文','12345'); 34 role_name 35 中文 36 12345 37 create role 'abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff'; 38 select role_name from mo_catalog.mo_role where role_name in ('abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff'); 39 role_name 40 abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff 41 create role 'default'; 42 select role_name from mo_catalog.mo_role where role_name in ('default'); 43 role_name 44 default 45 create if not exists role select; 46 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 9 near " if not exists role select;"; 47 create role a b c; 48 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 15 near " b c;"; 49 create role 'test:abc'; 50 internal error: the name "test:abc" is invalid 51 create role "test:abc"; 52 internal error: the name "test:abc" is invalid 53 create role `test:abc`; 54 internal error: the name "test:abc" is invalid 55 create role default; 56 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 19 near " default;"; 57 create user user_role identified by '12345678'; 58 create role user_role; 59 internal error: there is a user with the same name as the role user_role 60 create role ''; 61 internal error: the name "" is invalid 62 create role moadmin,public; 63 internal error: can not use the name moadmin. it is the name of the predefined role 64 create role if not exists moadmin,public; 65 select role_name from mo_catalog.mo_role where role_name in ('moadmin','public'); 66 role_name 67 moadmin 68 public 69 create role if not exists role_7; 70 select role_name from mo_catalog.mo_role where role_name = 'role_7'; 71 role_name 72 role_7 73 use mo_catalog; 74 create role if not exists role_role1,role_role2,role_role3,role_role4,role_role5,role_role6; 75 select role_name from mo_role where role_name like 'role_role%' order by role_name; 76 role_name 77 role_role1 78 role_role2 79 role_role3 80 role_role4 81 role_role5 82 role_role6 83 create role role_role1,role_role2,role_role3,role_role7,role_role8; 84 internal error: the role role_role1 exists 85 create role if not exists role_role1,role_role2,role_role3,role_role7,role_role8; 86 select role_name from mo_role where role_name like 'role_role%' order by role_name; 87 role_name 88 role_role1 89 role_role2 90 role_role3 91 role_role4 92 role_role5 93 role_role6 94 role_role7 95 role_role8 96 create role role_role9,role_role:10,role_role11; 97 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 ":10,role_role11;"; 98 select role_name from mo_role where role_name like 'role_role%' order by role_name; 99 role_name 100 role_role1 101 role_role2 102 role_role3 103 role_role4 104 role_role5 105 role_role6 106 role_role7 107 role_role8 108 create role if not exists role2; 109 create user role_user identified by '111111'; 110 grant insert,select on table *.* to role2; 111 use mo_catalog; 112 select role_name,obj_type,privilege_name,privilege_level from mo_role_privs where role_name='role2'; 113 role_name obj_type privilege_name privilege_level 114 role2 table insert *.* 115 role2 table select *.* 116 grant role2 to role_user; 117 select user_name,role_name,obj_type,privilege_name,privilege_level from mo_user_grant,mo_user,mo_role_privs where mo_user_grant.user_id=mo_user.user_id and mo_role_privs.role_id=mo_user_grant.role_id and role_name='role2'; 118 user_name role_name obj_type privilege_name privilege_level 119 role_user role2 table insert *.* 120 role_user role2 table select *.* 121 drop role role2; 122 select count(*) from mo_role_privs where role_name='role2'; 123 count(*) 124 0 125 select count(*) from mo_user_grant,mo_user,mo_role_privs where mo_user_grant.user_id=mo_user.user_id and mo_role_privs.role_id=mo_user_grant.role_id and role_name='role2'; 126 count(*) 127 0 128 create role role2; 129 grant insert,select on table *.* to role2; 130 select role_name,obj_type,privilege_name,privilege_level from mo_role_privs where role_name='role2'; 131 role_name obj_type privilege_name privilege_level 132 role2 table insert *.* 133 role2 table select *.* 134 create role if not exists role3; 135 grant create database on account * to role3; 136 select role_name,obj_type,privilege_name,privilege_level from mo_role_privs where role_name='role3'; 137 role_name obj_type privilege_name privilege_level 138 role3 account create database * 139 grant role3 to role_user; 140 grant ownership on table *.* to role3; 141 grant role3 to role_user; 142 select user_name,role_name,obj_type,privilege_name,privilege_level from mo_user_grant,mo_user,mo_role_privs where mo_user_grant.user_id=mo_user.user_id and mo_role_privs.role_id=mo_user_grant.role_id and role_name='role3'; 143 user_name role_name obj_type privilege_name privilege_level 144 role_user role3 account create database * 145 role_user role3 table table ownership *.* 146 drop user if exists user_prepare_01; 147 drop role if exists role_prepare_1; 148 create user user_prepare_01 identified by '123456'; 149 create role role_prepare_1; 150 create database if not exists p_db; 151 grant create table ,drop table on database *.* to role_prepare_1; 152 grant connect on account * to role_prepare_1; 153 grant insert,select on table *.* to role_prepare_1; 154 grant role_prepare_1 to user_prepare_01; 155 use p_db; 156 prepare stmtt from 'drop table if exists grant_table_30'; 157 execute stmtt; 158 prepare stmt from 'create table grant_table_30(a int)'; 159 execute stmt; 160 prepare stmt1 from 'insert into grant_table_30 values(?)'; 161 set @a=55; 162 execute stmt1 using @a; 163 prepare stmt2 from 'select * from grant_table_30'; 164 execute stmt2; 165 a 166 55 167 prepare stmt2 from 'update grant_table_30 set a=60'; 168 internal error: do not have privilege to execute the statement 169 execute stmt2; 170 internal error: do not have privilege to execute the statement 171 prepare stmt2 from 'insert into grant_table_30 select 89'; 172 execute stmt2; 173 prepare stmt3 from 'insert into grant_table_30 select * from grant_table_30'; 174 execute stmt3; 175 prepare stmt4 from 'show databases'; 176 internal error: do not have privilege to execute the statement 177 execute stmt4; 178 internal error: do not have privilege to execute the statement 179 prepare stmt5 from 'select "abc"'; 180 execute stmt5; 181 abc 182 abc 183 drop role if exists newrole, role_1234,12role,`role@hhhh123`,`role.123`,_newrole,role222; 184 drop role if exists role1,role2,role3,role4,role5,role6,role_7,user_role,u_role; 185 drop role if exists role_1,role_2,role_3,role_4,role_5,role_6,role_7,'中文','12345','default';; 186 drop role if exists `abcddddddfsfafaffsefsfsefljofiseosfjosisssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss24444444444444444444444444222222222@fffffffffffffffffffffffffffffffffffffffffffffffffffff`; 187 drop user if exists role_user,user_role; 188 drop role if exists role_role1,role_role2,role_role3,role_role4,role_role5,role_role6,role_role7,role_role8,u_role; 189 drop database if exists p_db;