mariadb/v_version.result at 11.4-mdev-36389-indexed-text-column-wrong-result - mariadb - GitFox

database/mariadb

mirror of https://github.com/MariaDB/server.git synced 2025-08-08 11:22:35 +03:00

Files

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

4 lines

55 B

Plaintext

Raw Permalink Blame History

	`SELECT sys_version FROM sys.version;`
	`sys_version`
	`1.5.2`