Debian Codegraph @

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

raw
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.schema_privileges
10 WHERE table_schema IN ('information_schema','mysql','test')
11 ORDER BY grantee, table_schema, privilege_type;
12 GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
13 SHOW DATABASES LIKE 'information_schema';
14 Database (information_schema)
15 information_schema
16 SHOW DATABASES LIKE 'mysql';
17 Database (mysql)
18 mysql
19 SHOW DATABASES LIKE 'test';
20 Database (test)
21 test
22 connect testuser1, localhost, testuser1, , db_datadict;
23 SELECT * FROM information_schema.schema_privileges
24 WHERE table_schema IN ('information_schema','mysql','test')
25 ORDER BY grantee, table_schema, privilege_type;
26 GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE
27 SHOW DATABASES LIKE 'information_schema';
28 Database (information_schema)
29 information_schema
30 SHOW DATABASES LIKE 'mysql';
31 Database (mysql)
32 SHOW DATABASES LIKE 'test';
33 Database (test)
34 connection default;
35 DROP USER 'testuser1'@'localhost';
36 DROP DATABASE db_datadict;