[MDEV-27468] Provide role privileges information within the information_schema Created: 2021-04-27 Updated: 2024-01-18 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Authentication and Privilege System, Information Schema |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Minor |
| Reporter: | Kyle Joiner (Inactive) | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 3 |
| Labels: | None | ||
| Description |
|
Provide role privileges information and assignment within the information_schema. It's about the role's counterpart of https://mariadb.com/kb/en/information-schema-user_privileges-table/ May be it should show roles too. Or may be there should be a separate INFORMATION_SCHEMA.ROLE_PRIVILEGES. |
| Comments |
| Comment by Daniel Black [ 2021-04-27 ] |
|
What isn't covered by https://mariadb.com/kb/en/information-schema-applicable_roles-table/ and https://mariadb.com/kb/en/information-schema-enabled_roles-table/ ? |
| Comment by Sergei Golubchik [ 2021-04-28 ] |
|
No, it's about the role's counterpart of https://mariadb.com/kb/en/information-schema-user_privileges-table/ May be it should show roles too. Or may be there should be a separate INFORMATION_SCHEMA.ROLE_PRIVILEGES. |