Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Create view for Column Privileges

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