[MDEV-32040] Global Privileges missing in INFORMATION_SCHEMA Created: 2023-08-30  Updated: 2023-10-04

Status: Open
Project: MariaDB Server
Component/s: Authentication and Privilege System, Information Schema
Fix Version/s: None

Type: Task Priority: Major
Reporter: Georg Richter Assignee: Georg Richter
Resolution: Unresolved Votes: 0
Labels: None


 Description   

From MariaDB documentation:

In MariaDB 10.4 and later, the mysql.global_priv table has replaced the mysql.user table, and mysql.user should be considered obsolete. It is now a view into mysql.global_priv created for compatibility with older applications and monitoring scripts. New tools are supposed to use INFORMATION_SCHEMA tables.

Either this is a documentation bug or a missing feature, since it is not possible to retrieve all privileges stored in mysql.global_priv via INFORMATION_SCHEMA.

Proposal:
Add a view INFORMATION_SCHEMA.GLOBAL_PRIVILEGES which returns values from mysql.global_priv in a human readable form. This will avoid to write a complex view for retrieving the privileges in client applications.



 Comments   
Comment by Daniel Black [ 2023-08-31 ]

This is currently in information_schema.user_privileges and included lower level privileges granted on *.*. Updated the docs to make this a little clearer.

What is missing is information_schema.PROC_PRIVILEGES or for procedure/function grants if that is desired.

Comment by Daniel Black [ 2023-09-01 ]

And PACKAGE, and PACKAGE_BODY.

Generated at Thu Feb 08 10:28:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.