1 ##############################################################################
2 # Testcases 3.2.9.2+3.2.9.3 INFORMATION_SCHEMA.SCHEMATA accessible information
3 ##############################################################################
4 DROP DATABASE IF EXISTS db_datadict;
5 CREATE DATABASE db_datadict;
6 DROP USER 'testuser1'@'localhost';
7 CREATE USER 'testuser1'@'localhost';
8 GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost';
9 SELECT * FROM information_schema.column_privileges
10 WHERE table_schema IN ('information_schema','mysql','test')
11 ORDER BY table_schema, table_name, column_name;
12 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
13 SHOW DATABASES LIKE 'information_schema';
14 Database (information_schema)
16 SHOW DATABASES LIKE 'mysql';
19 SHOW DATABASES LIKE 'test';
22 # Establish connection testuser1 (user=testuser1)
23 SELECT * FROM information_schema.column_privileges
24 WHERE table_schema IN ('information_schema','mysql','test')
25 ORDER BY table_schema, table_name, column_name;
26 GRANTEE TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE
27 SHOW DATABASES LIKE 'information_schema';
28 Database (information_schema)
30 SHOW DATABASES LIKE 'mysql';
32 SHOW DATABASES LIKE 'test';
35 # Switch to connection default and close connection testuser1
36 DROP USER 'testuser1'@'localhost';
37 DROP DATABASE db_datadict;