• Oleg Smirnov's avatar
    MDEV-24486 Add `table_privileges` view to the `sys` schema · 1a5e69b4
    Oleg Smirnov authored
    The existing INFORMATION_SCHEMA.TABLE_PRIVILEGES displays only those
    privileges that were specifically granted on the table level,
    whereas it may be useful to see privileges granted at the database
    and global level.
    
    This commit adds a new view `table_privileges` to the `sys` schema
    for that purpose. The view shows privileges on existing tables
    and views, combining all possible levels:
     - user_privileges
     - schema_privileges
     - table_privileges
    1a5e69b4
v_table_privileges.result 3.55 KB