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