Create view on table Privileges : Matadata « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. Matadata

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>








Related examples in the same category

1.Create view for base table and temporary table
2.Create view for columns
3.Create view for view information from INFORMATION_SCHEMA.VIEWS
4.Create view for column information
5.Create view for user authentication
6.Create view for database authentication
7.Create view for Column Privileges