Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Create view for user authentication

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>