Command Mysql MySQL

  1. Home
  2. MySQL
  3. Command Mysql
  4. 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>