github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/tenant/privilege/role3.result (about) 1 set global enable_privilege_cache = off; 2 drop role if exists role_r1; 3 create role role_r1; 4 drop database if exists d; 5 create database d; 6 use d; 7 create table t(a int); 8 revoke if exists create account on account * from role_r1,rx; 9 revoke if exists drop account on account * from role_r1,rx; 10 revoke if exists alter account on account * from role_r1,rx; 11 revoke if exists create user on account * from role_r1,rx; 12 revoke if exists drop user on account * from role_r1,rx; 13 revoke if exists alter user on account * from role_r1,rx; 14 revoke if exists create role on account * from role_r1,rx; 15 revoke if exists drop role on account * from role_r1,rx; 16 revoke if exists alter role on account * from role_r1,rx; 17 revoke if exists create database on account * from role_r1,rx; 18 revoke if exists drop database on account * from role_r1,rx; 19 revoke if exists show databases on account * from role_r1,rx; 20 revoke if exists connect on account * from role_r1,rx; 21 revoke if exists manage grants on account * from role_r1,rx; 22 revoke if exists all on account * from role_r1,rx; 23 revoke if exists ownership on account * from role_r1,rx; 24 internal error: the object type "account" do not support the privilege "ownership" 25 revoke if exists ownership on account * from role_r1,rx; 26 internal error: the object type "account" do not support the privilege "ownership" 27 revoke if exists ownership on account * from role_r1,rx; 28 internal error: the object type "account" do not support the privilege "ownership" 29 revoke if exists show tables on database * from role_r1,rx; 30 revoke if exists show tables on database *.* from role_r1,rx; 31 revoke if exists show tables on database d from role_r1,rx; 32 revoke if exists create table on database * from role_r1,rx; 33 revoke if exists create table on database *.* from role_r1,rx; 34 revoke if exists create table on database d from role_r1,rx; 35 revoke if exists create view on database * from role_r1,rx; 36 revoke if exists create view on database *.* from role_r1,rx; 37 revoke if exists create view on database d from role_r1,rx; 38 revoke if exists drop table on database * from role_r1,rx; 39 revoke if exists drop table on database *.* from role_r1,rx; 40 revoke if exists drop table on database d from role_r1,rx; 41 revoke if exists drop view on database * from role_r1,rx; 42 revoke if exists drop view on database *.* from role_r1,rx; 43 revoke if exists drop view on database d from role_r1,rx; 44 revoke if exists alter table on database * from role_r1,rx; 45 revoke if exists alter table on database *.* from role_r1,rx; 46 revoke if exists alter table on database d from role_r1,rx; 47 revoke if exists alter view on database * from role_r1,rx; 48 revoke if exists alter view on database *.* from role_r1,rx; 49 revoke if exists alter view on database d from role_r1,rx; 50 revoke if exists all on database * from role_r1,rx; 51 revoke if exists all on database *.* from role_r1,rx; 52 revoke if exists all on database d from role_r1,rx; 53 revoke if exists ownership on database * from role_r1,rx; 54 revoke if exists ownership on database *.* from role_r1,rx; 55 revoke if exists ownership on database d from role_r1,rx; 56 revoke if exists select on table * from role_r1,rx; 57 revoke if exists select on table *.* from role_r1,rx; 58 revoke if exists select on table d.* from role_r1,rx; 59 revoke if exists select on table d.t from role_r1,rx; 60 revoke if exists select on table t from role_r1,rx; 61 revoke if exists insert on table * from role_r1,rx; 62 revoke if exists insert on table *.* from role_r1,rx; 63 revoke if exists insert on table d.* from role_r1,rx; 64 revoke if exists insert on table d.t from role_r1,rx; 65 revoke if exists insert on table t from role_r1,rx; 66 revoke if exists update on table * from role_r1,rx; 67 revoke if exists update on table *.* from role_r1,rx; 68 revoke if exists update on table d.* from role_r1,rx; 69 revoke if exists update on table d.t from role_r1,rx; 70 revoke if exists update on table t from role_r1,rx; 71 revoke if exists truncate on table * from role_r1,rx; 72 revoke if exists truncate on table *.* from role_r1,rx; 73 revoke if exists truncate on table d.* from role_r1,rx; 74 revoke if exists truncate on table d.t from role_r1,rx; 75 revoke if exists truncate on table t from role_r1,rx; 76 revoke if exists delete on table * from role_r1,rx; 77 revoke if exists delete on table *.* from role_r1,rx; 78 revoke if exists delete on table d.* from role_r1,rx; 79 revoke if exists delete on table d.t from role_r1,rx; 80 revoke if exists delete on table t from role_r1,rx; 81 revoke if exists reference on table * from role_r1,rx; 82 revoke if exists reference on table *.* from role_r1,rx; 83 revoke if exists reference on table d.* from role_r1,rx; 84 revoke if exists reference on table d.t from role_r1,rx; 85 revoke if exists reference on table t from role_r1,rx; 86 revoke if exists index on table * from role_r1,rx; 87 revoke if exists index on table *.* from role_r1,rx; 88 revoke if exists index on table d.* from role_r1,rx; 89 revoke if exists index on table d.t from role_r1,rx; 90 revoke if exists index on table t from role_r1,rx; 91 revoke if exists all on table * from role_r1,rx; 92 revoke if exists all on table *.* from role_r1,rx; 93 revoke if exists all on table d.* from role_r1,rx; 94 revoke if exists all on table d.t from role_r1,rx; 95 revoke if exists all on table t from role_r1,rx; 96 revoke if exists ownership on table * from role_r1,rx; 97 revoke if exists ownership on table *.* from role_r1,rx; 98 revoke if exists ownership on table d.* from role_r1,rx; 99 revoke if exists ownership on table d.t from role_r1,rx; 100 revoke if exists ownership on table t from role_r1,rx; 101 revoke if exists execute on table * from role_r1,rx; 102 revoke if exists execute on table *.* from role_r1,rx; 103 revoke if exists execute on table d.* from role_r1,rx; 104 revoke if exists execute on table d.t from role_r1,rx; 105 revoke if exists execute on table t from role_r1,rx; 106 revoke create account on account * from role_r1,rx; 107 internal error: there is no role rx 108 revoke drop account on account * from role_r1,rx; 109 internal error: there is no role rx 110 revoke alter account on account * from role_r1,rx; 111 internal error: there is no role rx 112 revoke create user on account * from role_r1,rx; 113 internal error: there is no role rx 114 revoke drop user on account * from role_r1,rx; 115 internal error: there is no role rx 116 revoke alter user on account * from role_r1,rx; 117 internal error: there is no role rx 118 revoke create role on account * from role_r1,rx; 119 internal error: there is no role rx 120 revoke drop role on account * from role_r1,rx; 121 internal error: there is no role rx 122 revoke alter role on account * from role_r1,rx; 123 internal error: there is no role rx 124 revoke create database on account * from role_r1,rx; 125 internal error: there is no role rx 126 revoke drop database on account * from role_r1,rx; 127 internal error: there is no role rx 128 revoke show databases on account * from role_r1,rx; 129 internal error: there is no role rx 130 revoke connect on account * from role_r1,rx; 131 internal error: there is no role rx 132 revoke manage grants on account * from role_r1,rx; 133 internal error: there is no role rx 134 revoke all on account * from role_r1,rx; 135 internal error: there is no role rx 136 revoke ownership on account * from role_r1,rx; 137 internal error: there is no role rx 138 revoke ownership on account * from role_r1,rx; 139 internal error: there is no role rx 140 revoke ownership on account * from role_r1,rx; 141 internal error: there is no role rx 142 revoke show tables on database * from role_r1,rx; 143 internal error: there is no role rx 144 revoke show tables on database *.* from role_r1,rx; 145 internal error: there is no role rx 146 revoke show tables on database d from role_r1,rx; 147 internal error: there is no role rx 148 revoke create table on database * from role_r1,rx; 149 internal error: there is no role rx 150 revoke create table on database *.* from role_r1,rx; 151 internal error: there is no role rx 152 revoke create table on database d from role_r1,rx; 153 internal error: there is no role rx 154 revoke create view on database * from role_r1,rx; 155 internal error: there is no role rx 156 revoke create view on database *.* from role_r1,rx; 157 internal error: there is no role rx 158 revoke create view on database d from role_r1,rx; 159 internal error: there is no role rx 160 revoke drop table on database * from role_r1,rx; 161 internal error: there is no role rx 162 revoke drop table on database *.* from role_r1,rx; 163 internal error: there is no role rx 164 revoke drop table on database d from role_r1,rx; 165 internal error: there is no role rx 166 revoke drop view on database * from role_r1,rx; 167 internal error: there is no role rx 168 revoke drop view on database *.* from role_r1,rx; 169 internal error: there is no role rx 170 revoke drop view on database d from role_r1,rx; 171 internal error: there is no role rx 172 revoke alter table on database * from role_r1,rx; 173 internal error: there is no role rx 174 revoke alter table on database *.* from role_r1,rx; 175 internal error: there is no role rx 176 revoke alter table on database d from role_r1,rx; 177 internal error: there is no role rx 178 revoke alter view on database * from role_r1,rx; 179 internal error: there is no role rx 180 revoke alter view on database *.* from role_r1,rx; 181 internal error: there is no role rx 182 revoke alter view on database d from role_r1,rx; 183 internal error: there is no role rx 184 revoke all on database * from role_r1,rx; 185 internal error: there is no role rx 186 revoke all on database *.* from role_r1,rx; 187 internal error: there is no role rx 188 revoke all on database d from role_r1,rx; 189 internal error: there is no role rx 190 revoke ownership on database * from role_r1,rx; 191 internal error: there is no role rx 192 revoke ownership on database *.* from role_r1,rx; 193 internal error: there is no role rx 194 revoke ownership on database d from role_r1,rx; 195 internal error: there is no role rx 196 revoke select on table * from role_r1,rx; 197 internal error: there is no role rx 198 revoke select on table *.* from role_r1,rx; 199 internal error: there is no role rx 200 revoke select on table d.* from role_r1,rx; 201 internal error: there is no role rx 202 revoke select on table d.t from role_r1,rx; 203 internal error: there is no role rx 204 revoke select on table t from role_r1,rx; 205 internal error: there is no role rx 206 revoke insert on table * from role_r1,rx; 207 internal error: there is no role rx 208 revoke insert on table *.* from role_r1,rx; 209 internal error: there is no role rx 210 revoke insert on table d.* from role_r1,rx; 211 internal error: there is no role rx 212 revoke insert on table d.t from role_r1,rx; 213 internal error: there is no role rx 214 revoke insert on table t from role_r1,rx; 215 internal error: there is no role rx 216 revoke update on table * from role_r1,rx; 217 internal error: there is no role rx 218 revoke update on table *.* from role_r1,rx; 219 internal error: there is no role rx 220 revoke update on table d.* from role_r1,rx; 221 internal error: there is no role rx 222 revoke update on table d.t from role_r1,rx; 223 internal error: there is no role rx 224 revoke update on table t from role_r1,rx; 225 internal error: there is no role rx 226 revoke truncate on table * from role_r1,rx; 227 internal error: there is no role rx 228 revoke truncate on table *.* from role_r1,rx; 229 internal error: there is no role rx 230 revoke truncate on table d.* from role_r1,rx; 231 internal error: there is no role rx 232 revoke truncate on table d.t from role_r1,rx; 233 internal error: there is no role rx 234 revoke truncate on table t from role_r1,rx; 235 internal error: there is no role rx 236 revoke delete on table * from role_r1,rx; 237 internal error: there is no role rx 238 revoke delete on table *.* from role_r1,rx; 239 internal error: there is no role rx 240 revoke delete on table d.* from role_r1,rx; 241 internal error: there is no role rx 242 revoke delete on table d.t from role_r1,rx; 243 internal error: there is no role rx 244 revoke delete on table t from role_r1,rx; 245 internal error: there is no role rx 246 revoke reference on table * from role_r1,rx; 247 internal error: there is no role rx 248 revoke reference on table *.* from role_r1,rx; 249 internal error: there is no role rx 250 revoke reference on table d.* from role_r1,rx; 251 internal error: there is no role rx 252 revoke reference on table d.t from role_r1,rx; 253 internal error: there is no role rx 254 revoke reference on table t from role_r1,rx; 255 internal error: there is no role rx 256 revoke index on table * from role_r1,rx; 257 internal error: there is no role rx 258 revoke index on table *.* from role_r1,rx; 259 internal error: there is no role rx 260 revoke index on table d.* from role_r1,rx; 261 internal error: there is no role rx 262 revoke index on table d.t from role_r1,rx; 263 internal error: there is no role rx 264 revoke index on table t from role_r1,rx; 265 internal error: there is no role rx 266 revoke all on table * from role_r1,rx; 267 internal error: there is no role rx 268 revoke all on table *.* from role_r1,rx; 269 internal error: there is no role rx 270 revoke all on table d.* from role_r1,rx; 271 internal error: there is no role rx 272 revoke all on table d.t from role_r1,rx; 273 internal error: there is no role rx 274 revoke all on table t from role_r1,rx; 275 internal error: there is no role rx 276 revoke ownership on table * from role_r1,rx; 277 internal error: there is no role rx 278 revoke ownership on table *.* from role_r1,rx; 279 internal error: there is no role rx 280 revoke ownership on table d.* from role_r1,rx; 281 internal error: there is no role rx 282 revoke ownership on table d.t from role_r1,rx; 283 internal error: there is no role rx 284 revoke ownership on table t from role_r1,rx; 285 internal error: there is no role rx 286 revoke execute on table * from role_r1,rx; 287 internal error: there is no role rx 288 revoke execute on table *.* from role_r1,rx; 289 internal error: there is no role rx 290 revoke execute on table d.* from role_r1,rx; 291 internal error: there is no role rx 292 revoke execute on table d.t from role_r1,rx; 293 internal error: there is no role rx 294 revoke execute on table t from role_r1,rx; 295 internal error: there is no role rx 296 drop role role_r1; 297 drop database if exists d; 298 set global enable_privilege_cache = on;