Edit File: is_schema_privileges_is_mysql_test.result
############################################################################## # Testcases 3.2.9.2+3.2.9.3 INFORMATION_SCHEMA.SCHEMATA accessible information ############################################################################## DROP DATABASE IF EXISTS db_datadict; CREATE DATABASE db_datadict; DROP USER 'testuser1'@'localhost'; CREATE USER 'testuser1'@'localhost'; GRANT SELECT ON db_datadict.* TO 'testuser1'@'localhost'; SELECT * FROM information_schema.schema_privileges WHERE table_schema IN ('information_schema','mysql','test') ORDER BY grantee, table_schema, privilege_type; GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE ''@'%' def test ALTER NO ''@'%' def test CREATE NO ''@'%' def test CREATE ROUTINE NO ''@'%' def test CREATE TEMPORARY TABLES NO ''@'%' def test CREATE VIEW NO ''@'%' def test DELETE NO ''@'%' def test DROP NO ''@'%' def test EVENT NO ''@'%' def test INDEX NO ''@'%' def test INSERT NO ''@'%' def test LOCK TABLES NO ''@'%' def test REFERENCES NO ''@'%' def test SELECT NO ''@'%' def test SHOW VIEW NO ''@'%' def test TRIGGER NO ''@'%' def test UPDATE NO SHOW DATABASES LIKE 'information_schema'; Database (information_schema) information_schema SHOW DATABASES LIKE 'mysql'; Database (mysql) mysql SHOW DATABASES LIKE 'test'; Database (test) test # Establish connection testuser1 (user=testuser1) SELECT * FROM information_schema.schema_privileges WHERE table_schema IN ('information_schema','mysql','test') ORDER BY grantee, table_schema, privilege_type; GRANTEE TABLE_CATALOG TABLE_SCHEMA PRIVILEGE_TYPE IS_GRANTABLE SHOW DATABASES LIKE 'information_schema'; Database (information_schema) information_schema SHOW DATABASES LIKE 'mysql'; Database (mysql) SHOW DATABASES LIKE 'test'; Database (test) test # Switch to connection default and close connection testuser1 DROP USER 'testuser1'@'localhost'; DROP DATABASE db_datadict;
Back to File Manager