3 commits

Author	SHA1	Message	Date
Oleg Smirnov	70de4075a1	MDEV-24486 Rename the view sys.table_privileges to sys.privileges_by_table_by_level ... This is a follow-up for the initial MDEV-24486 commit. It renames the view sys.table_privileges to sys.privileges_by_table_by_level and adds some more tests displaying privilege levels GLOBAL and SCHEMA	2023-12-08 19:29:02 +03:00
Oleg Smirnov	1a5e69b42b	MDEV-24486 Add table_privileges view to the sys schema ... 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	2023-12-05 11:42:47 +03:00
Vladislav Vaintroub	4bac804c90	MDEV-9077 add sys_schema from https://github.com/mysql/mysql-sys	2021-03-18 08:02:29 +01:00