[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: |
| 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. |