Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Create view for database authentication

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