mysql>
mysql> CREATE OR REPLACE VIEW TABLE_AUTHS
-> (GRANTOR, GRANTEE, TABLE_CREATOR, TABLE_NAME,
-> PRIVILEGE, WITHGRANTOPT) AS
-> SELECT 'UNKNOWN', UPPER(GRANTEE), UPPER(TABLE_SCHEMA),
-> UPPER(TABLE_NAME), PRIVILEGE_TYPE, IS_GRANTABLE
-> FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>