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