Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Create view on table Privileges

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>