Debian Codegraph @

mysql-test/suite/funcs_1/r/is_column_privileges.result

raw
1 SHOW TABLES FROM information_schema LIKE 'COLUMN_PRIVILEGES';
2 Tables_in_information_schema (COLUMN_PRIVILEGES)
3 COLUMN_PRIVILEGES
4 #######################################################################
5 # Testcase 3.2.1.1: INFORMATION_SCHEMA tables can be queried via SELECT
6 #######################################################################
7 DROP VIEW IF EXISTS test.v1;
8 DROP PROCEDURE IF EXISTS test.p1;
9 DROP FUNCTION IF EXISTS test.f1;
10 CREATE VIEW test.v1 AS SELECT * FROM information_schema.COLUMN_PRIVILEGES;
11 CREATE PROCEDURE test.p1() SELECT * FROM information_schema.COLUMN_PRIVILEGES;
12 CREATE FUNCTION test.f1() returns BIGINT
13 BEGIN
14 DECLARE counter BIGINT DEFAULT NULL;
15 SELECT COUNT(*) INTO counter FROM information_schema.COLUMN_PRIVILEGES;
16 RETURN counter;
17 END//
18 # Attention: The printing of the next result sets is disabled.
19 SELECT * FROM information_schema.COLUMN_PRIVILEGES;
20 SELECT * FROM test.v1;
21 CALL test.p1;
22 SELECT test.f1();
23 DROP VIEW test.v1;
24 DROP PROCEDURE test.p1;
25 DROP FUNCTION test.f1;
26 #########################################################################
27 # Testcase 3.2.5.1: INFORMATION_SCHEMA.COLUMN_PRIVILEGES layout
28 #########################################################################
29 DESCRIBE information_schema.COLUMN_PRIVILEGES;
30 Field Type Null Key Default Extra
31 GRANTEE varchar(385) NO NULL
32 TABLE_CATALOG varchar(512) NO NULL
33 TABLE_SCHEMA varchar(64) NO NULL
34 TABLE_NAME varchar(64) NO NULL
35 COLUMN_NAME varchar(64) NO NULL
36 PRIVILEGE_TYPE varchar(64) NO NULL
37 IS_GRANTABLE varchar(3) NO NULL
38 SHOW CREATE TABLE information_schema.COLUMN_PRIVILEGES;
39 Table Create Table
40 COLUMN_PRIVILEGES CREATE TEMPORARY TABLE `COLUMN_PRIVILEGES` (
41 `GRANTEE` varchar(385) NOT NULL,
42 `TABLE_CATALOG` varchar(512) NOT NULL,
43 `TABLE_SCHEMA` varchar(64) NOT NULL,
44 `TABLE_NAME` varchar(64) NOT NULL,
45 `COLUMN_NAME` varchar(64) NOT NULL,
46 `PRIVILEGE_TYPE` varchar(64) NOT NULL,
47 `IS_GRANTABLE` varchar(3) NOT NULL
48 ) ENGINE=MEMORY DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
49 SHOW COLUMNS FROM information_schema.COLUMN_PRIVILEGES;
50 Field Type Null Key Default Extra
51 GRANTEE varchar(385) NO NULL
52 TABLE_CATALOG varchar(512) NO NULL
53 TABLE_SCHEMA varchar(64) NO NULL
54 TABLE_NAME varchar(64) NO NULL
55 COLUMN_NAME varchar(64) NO NULL
56 PRIVILEGE_TYPE varchar(64) NO NULL
57 IS_GRANTABLE varchar(3) NO NULL
58 SELECT table_catalog, table_schema, table_name, column_name, privilege_type
59 FROM information_schema.column_privileges WHERE table_catalog IS NOT NULL;
60 table_catalog table_schema table_name column_name privilege_type
61 ######################################################################
62 # Testcase 3.2.5.2+3.2.5.3+3.2.5.4:
63 # INFORMATION_SCHEMA.COLUMN_PRIVILEGES accessible information
64 ######################################################################
65 DROP DATABASE IF EXISTS db_datadict;
66 CREATE DATABASE db_datadict;
67 CREATE TABLE db_datadict.t1 (f1 INT, f2 DECIMAL, f3 TEXT)
68 ENGINE = <other_engine_type>;
69 USE db_datadict;
70 DROP USER 'testuser1'@'localhost';
71 CREATE USER 'testuser1'@'localhost';
72 DROP USER 'testuser2'@'localhost';
73 CREATE USER 'testuser2'@'localhost';
74 DROP USER 'testuser3'@'localhost';
75 CREATE USER 'testuser3'@'localhost';
76 GRANT SELECT(f1, f3) ON db_datadict.t1 TO 'testuser1'@'localhost';
77 GRANT INSERT(f1) ON db_datadict.t1 TO 'testuser1'@'localhost';
78 GRANT UPDATE(f2) ON db_datadict.t1 TO 'testuser1'@'localhost';
79 GRANT SELECT(f2) ON db_datadict.t1 TO 'testuser2'@'localhost';
80 GRANT INSERT, SELECT ON db_datadict.t1 TO 'testuser3'@'localhost';
81 GRANT SELECT(f3) ON db_datadict.t1 TO 'testuser3'@'localhost';
82 GRANT INSERT, SELECT ON db_datadict.t1 TO 'testuser3'@'localhost'
83 WITH GRANT OPTION;
84 GRANT ALL ON db_datadict.* TO 'testuser3'@'localhost';
85 SELECT * FROM information_schema.column_privileges
86 WHERE grantee LIKE '''testuser%'''
87 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
88 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
89 'testuser1'@'localhost' def db_datadict t1 f1 INSERT NO
90 'testuser1'@'localhost' def db_datadict t1 f1 SELECT NO
91 'testuser1'@'localhost' def db_datadict t1 f2 UPDATE NO
92 'testuser1'@'localhost' def db_datadict t1 f3 SELECT NO
93 'testuser2'@'localhost' def db_datadict t1 f2 SELECT NO
94 'testuser3'@'localhost' def db_datadict t1 f3 SELECT YES
95 GRANT UPDATE(f3) ON db_datadict.t1 TO 'testuser1'@'localhost'
96 WITH GRANT OPTION;
97 SELECT * FROM information_schema.column_privileges
98 WHERE grantee LIKE '''testuser%'''
99 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
100 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
101 'testuser1'@'localhost' def db_datadict t1 f1 INSERT YES
102 'testuser1'@'localhost' def db_datadict t1 f1 SELECT YES
103 'testuser1'@'localhost' def db_datadict t1 f2 UPDATE YES
104 'testuser1'@'localhost' def db_datadict t1 f3 SELECT YES
105 'testuser1'@'localhost' def db_datadict t1 f3 UPDATE YES
106 'testuser2'@'localhost' def db_datadict t1 f2 SELECT NO
107 'testuser3'@'localhost' def db_datadict t1 f3 SELECT YES
108 connect testuser1, localhost, testuser1, , db_datadict;
109 SELECT * FROM information_schema.column_privileges
110 WHERE grantee LIKE '''testuser%'''
111 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
112 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
113 'testuser1'@'localhost' def db_datadict t1 f1 INSERT YES
114 'testuser1'@'localhost' def db_datadict t1 f1 SELECT YES
115 'testuser1'@'localhost' def db_datadict t1 f2 UPDATE YES
116 'testuser1'@'localhost' def db_datadict t1 f3 SELECT YES
117 'testuser1'@'localhost' def db_datadict t1 f3 UPDATE YES
118 connect testuser2, localhost, testuser2, , db_datadict;
119 SELECT * FROM information_schema.column_privileges
120 WHERE grantee LIKE '''testuser%'''
121 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
122 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
123 'testuser2'@'localhost' def db_datadict t1 f2 SELECT NO
124 connect testuser3, localhost, testuser3, , db_datadict;
125 # FIXME: Is it correct that granted TABLES do not occur in COLUMN_PRIVILEGES?
126 SELECT * FROM information_schema.table_privileges
127 WHERE grantee LIKE '''testuser%'''
128 ORDER BY grantee,table_schema,table_name,privilege_type;
129 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME PRIVILEGE_TYPE IS_GRANTABLE
130 'testuser3'@'localhost' def db_datadict t1 INSERT YES
131 'testuser3'@'localhost' def db_datadict t1 SELECT YES
132 SELECT * FROM information_schema.schema_privileges
133 WHERE grantee LIKE '''testuser%'''
134 ORDER BY grantee,table_schema,privilege_type;
135 GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
136 'testuser3'@'localhost' def db_datadict ALTER NO
137 'testuser3'@'localhost' def db_datadict ALTER ROUTINE NO
138 'testuser3'@'localhost' def db_datadict CREATE NO
139 'testuser3'@'localhost' def db_datadict CREATE ROUTINE NO
140 'testuser3'@'localhost' def db_datadict CREATE TEMPORARY TABLES NO
141 'testuser3'@'localhost' def db_datadict CREATE VIEW NO
142 'testuser3'@'localhost' def db_datadict DELETE NO
143 'testuser3'@'localhost' def db_datadict DELETE HISTORY NO
144 'testuser3'@'localhost' def db_datadict DROP NO
145 'testuser3'@'localhost' def db_datadict EVENT NO
146 'testuser3'@'localhost' def db_datadict EXECUTE NO
147 'testuser3'@'localhost' def db_datadict INDEX NO
148 'testuser3'@'localhost' def db_datadict INSERT NO
149 'testuser3'@'localhost' def db_datadict LOCK TABLES NO
150 'testuser3'@'localhost' def db_datadict REFERENCES NO
151 'testuser3'@'localhost' def db_datadict SELECT NO
152 'testuser3'@'localhost' def db_datadict SHOW CREATE ROUTINE NO
153 'testuser3'@'localhost' def db_datadict SHOW VIEW NO
154 'testuser3'@'localhost' def db_datadict TRIGGER NO
155 'testuser3'@'localhost' def db_datadict UPDATE NO
156 SELECT * FROM information_schema.column_privileges
157 WHERE grantee LIKE '''testuser%'''
158 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
159 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
160 'testuser3'@'localhost' def db_datadict t1 f3 SELECT YES
161 GRANT SELECT(f1, f3) ON db_datadict.t1 TO 'testuser2'@'localhost';
162 # FIXME: Is it intended that *my* grants to others are *NOT* shown here?
163 SELECT * FROM information_schema.column_privileges
164 WHERE grantee LIKE '''testuser%'''
165 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
166 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
167 'testuser3'@'localhost' def db_datadict t1 f3 SELECT YES
168 connection testuser2;
169 SELECT * FROM information_schema.column_privileges
170 WHERE grantee LIKE '''testuser%'''
171 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
172 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
173 'testuser2'@'localhost' def db_datadict t1 f1 SELECT NO
174 'testuser2'@'localhost' def db_datadict t1 f2 SELECT NO
175 'testuser2'@'localhost' def db_datadict t1 f3 SELECT NO
176 connection default;
177 disconnect testuser1;
178 disconnect testuser2;
179 disconnect testuser3;
180 DROP DATABASE db_datadict;
181 DROP USER 'testuser1'@'localhost';
182 DROP USER 'testuser2'@'localhost';
183 DROP USER 'testuser3'@'localhost';
184 ################################################################################
185 # 3.2.1.13+3.2.1.14+3.2.1.15: INFORMATION_SCHEMA.COLUMN_PRIVILEGES modifications
186 ################################################################################
187 DROP DATABASE IF EXISTS db_datadict;
188 CREATE DATABASE db_datadict;
189 CREATE TABLE db_datadict.my_table (f1 BIGINT, f2 CHAR(10), f3 DATE)
190 ENGINE = <engine_type>;
191 DROP USER 'testuser1'@'localhost';
192 CREATE USER 'testuser1'@'localhost';
193 GRANT ALL ON test.* TO 'testuser1'@'localhost';
194 SELECT * FROM information_schema.column_privileges
195 WHERE table_name = 'my_table'
196 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
197 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
198 SHOW GRANTS FOR 'testuser1'@'localhost';
199 Grants for testuser1@localhost
200 GRANT USAGE ON *.* TO `testuser1`@`localhost`
201 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
202 connect testuser1, localhost, testuser1, , test;
203 SELECT * FROM information_schema.column_privileges
204 WHERE table_name = 'my_table'
205 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
206 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
207 SHOW GRANTS FOR 'testuser1'@'localhost';
208 Grants for testuser1@localhost
209 GRANT USAGE ON *.* TO `testuser1`@`localhost`
210 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
211 connection default;
212 GRANT SELECT (f1,f3) ON db_datadict.my_table TO 'testuser1'@'localhost';
213 SELECT * FROM information_schema.column_privileges
214 WHERE table_name = 'my_table'
215 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
216 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
217 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
218 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
219 SHOW GRANTS FOR 'testuser1'@'localhost';
220 Grants for testuser1@localhost
221 GRANT USAGE ON *.* TO `testuser1`@`localhost`
222 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
223 GRANT SELECT (`f3`, `f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
224 connection testuser1;
225 SELECT * FROM information_schema.column_privileges
226 WHERE table_name = 'my_table'
227 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
228 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
229 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
230 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
231 SHOW GRANTS FOR 'testuser1'@'localhost';
232 Grants for testuser1@localhost
233 GRANT USAGE ON *.* TO `testuser1`@`localhost`
234 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
235 GRANT SELECT (`f3`, `f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
236 connection default;
237 ALTER TABLE db_datadict.my_table DROP COLUMN f3;
238 GRANT UPDATE (f1) ON db_datadict.my_table TO 'testuser1'@'localhost';
239 SELECT * FROM information_schema.column_privileges
240 WHERE table_name = 'my_table'
241 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
242 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
243 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
244 'testuser1'@'localhost' def db_datadict my_table f1 UPDATE NO
245 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
246 SHOW GRANTS FOR 'testuser1'@'localhost';
247 Grants for testuser1@localhost
248 GRANT USAGE ON *.* TO `testuser1`@`localhost`
249 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
250 GRANT SELECT (`f3`, `f1`), UPDATE (`f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
251 connection testuser1;
252 SELECT * FROM information_schema.column_privileges
253 WHERE table_name = 'my_table'
254 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
255 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
256 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
257 'testuser1'@'localhost' def db_datadict my_table f1 UPDATE NO
258 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
259 SHOW GRANTS FOR 'testuser1'@'localhost';
260 Grants for testuser1@localhost
261 GRANT USAGE ON *.* TO `testuser1`@`localhost`
262 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
263 GRANT SELECT (`f3`, `f1`), UPDATE (`f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
264 SELECT f1, f3 FROM db_datadict.my_table;
265 ERROR 42S22: Unknown column 'f3' in 'SELECT'
266 connection default;
267 ALTER TABLE db_datadict.my_table CHANGE COLUMN f1 my_col BIGINT;
268 SELECT * FROM information_schema.column_privileges
269 WHERE table_name = 'my_table'
270 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
271 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
272 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
273 'testuser1'@'localhost' def db_datadict my_table f1 UPDATE NO
274 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
275 SHOW GRANTS FOR 'testuser1'@'localhost';
276 Grants for testuser1@localhost
277 GRANT USAGE ON *.* TO `testuser1`@`localhost`
278 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
279 GRANT SELECT (`f3`, `f1`), UPDATE (`f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
280 connection testuser1;
281 SELECT * FROM information_schema.column_privileges
282 WHERE table_name = 'my_table'
283 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
284 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
285 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
286 'testuser1'@'localhost' def db_datadict my_table f1 UPDATE NO
287 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
288 SHOW GRANTS FOR 'testuser1'@'localhost';
289 Grants for testuser1@localhost
290 GRANT USAGE ON *.* TO `testuser1`@`localhost`
291 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
292 GRANT SELECT (`f3`, `f1`), UPDATE (`f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
293 connection default;
294 DROP TABLE db_datadict.my_table;
295 SELECT * FROM information_schema.column_privileges
296 WHERE table_name = 'my_table'
297 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
298 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
299 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
300 'testuser1'@'localhost' def db_datadict my_table f1 UPDATE NO
301 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
302 SHOW GRANTS FOR 'testuser1'@'localhost';
303 Grants for testuser1@localhost
304 GRANT USAGE ON *.* TO `testuser1`@`localhost`
305 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
306 GRANT SELECT (`f3`, `f1`), UPDATE (`f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
307 connection testuser1;
308 SELECT * FROM information_schema.column_privileges
309 WHERE table_name = 'my_table'
310 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
311 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
312 'testuser1'@'localhost' def db_datadict my_table f1 SELECT NO
313 'testuser1'@'localhost' def db_datadict my_table f1 UPDATE NO
314 'testuser1'@'localhost' def db_datadict my_table f3 SELECT NO
315 SHOW GRANTS FOR 'testuser1'@'localhost';
316 Grants for testuser1@localhost
317 GRANT USAGE ON *.* TO `testuser1`@`localhost`
318 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
319 GRANT SELECT (`f3`, `f1`), UPDATE (`f1`) ON `db_datadict`.`my_table` TO `testuser1`@`localhost`
320 connection default;
321 REVOKE ALL ON db_datadict.my_table FROM 'testuser1'@'localhost';
322 SELECT * FROM information_schema.column_privileges
323 WHERE table_name = 'my_table'
324 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
325 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
326 SHOW GRANTS FOR 'testuser1'@'localhost';
327 Grants for testuser1@localhost
328 GRANT USAGE ON *.* TO `testuser1`@`localhost`
329 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
330 connection testuser1;
331 SELECT * FROM information_schema.column_privileges
332 WHERE table_name = 'my_table'
333 ORDER BY grantee, table_schema,table_name,column_name,privilege_type;
334 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
335 SHOW GRANTS FOR 'testuser1'@'localhost';
336 Grants for testuser1@localhost
337 GRANT USAGE ON *.* TO `testuser1`@`localhost`
338 GRANT ALL PRIVILEGES ON `test`.* TO `testuser1`@`localhost`
339 connection default;
340 disconnect testuser1;
341 DROP USER 'testuser1'@'localhost';
342 DROP DATABASE db_datadict;
343 ########################################################################
344 # Testcases 3.2.1.3-3.2.1.5 + 3.2.1.8-3.2.1.12: INSERT/UPDATE/DELETE and
345 # DDL on INFORMATION_SCHEMA table are not supported
346 ########################################################################
347 DROP DATABASE IF EXISTS db_datadict;
348 CREATE DATABASE db_datadict;
349 CREATE TABLE db_datadict.t1 (f1 BIGINT, f2 BIGINT)
350 ENGINE = <engine_type>;
351 DROP USER 'testuser1'@'localhost';
352 CREATE USER 'testuser1'@'localhost';
353 GRANT SELECT (f1) ON db_datadict.t1 TO 'testuser1'@'localhost';
354 INSERT INTO information_schema.column_privileges
355 SELECT * FROM information_schema.column_privileges;
356 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
357 UPDATE information_schema.column_privileges SET table_schema = 'test'
358 WHERE table_name = 't1';
359 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
360 DELETE FROM information_schema.column_privileges WHERE table_name = 't1';
361 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
362 TRUNCATE information_schema.column_privileges;
363 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
364 CREATE INDEX my_idx_on_tables
365 ON information_schema.column_privileges(table_schema);
366 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
367 ALTER TABLE information_schema.column_privileges ADD f1 INT;
368 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
369 DROP TABLE information_schema.column_privileges;
370 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
371 ALTER TABLE information_schema.column_privileges
372 RENAME db_datadict.column_privileges;
373 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
374 ALTER TABLE information_schema.column_privileges
375 RENAME information_schema.xcolumn_privileges;
376 ERROR 42000: Access denied for user 'root'@'localhost' to database 'information_schema'
377 DROP DATABASE db_datadict;
378 DROP USER 'testuser1'@'localhost';