CREATE USER foo;

CREATE USER FOO;

GRANT SELECT ON test.* TO foo;

GRANT SELECT ON test.* TO FOO;

CREATE DEFINER=foo SQL SECURITY INVOKER VIEW v1 AS SELECT 1 AS c1;

--connect (FOO, localhost, FOO, , test)

--connection FOO

SELECT CURRENT_USER;

--vertical_results

--query_vertical SELECT * FROM INFORMATION_SCHEMA.VIEWS

--horizontal_results

--disconnect FOO

--connection default

DROP VIEW v1;

DROP USER foo;

DROP USER FOO;

...

SELECT CURRENT_USER;

CURRENT_USER

FOO@%

SELECT * FROM INFORMATION_SCHEMA.VIEWS;

TABLE_CATALOG	def

TABLE_SCHEMA	test

TABLE_NAME	v1

VIEW_DEFINITION	select 1 AS `c1`

CHECK_OPTION	NONE

IS_UPDATABLE	NO

DEFINER	foo@%

SECURITY_TYPE	INVOKER

CHARACTER_SET_CLIENT	latin1

COLLATION_CONNECTION	latin1_swedish_ci

...