Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5, 10.1, 10.2, 10.3, 10.4
-
None
Description
as root |
create view processlist_as_root as select * from information_schema.processlist; |
as unpriivleged user |
select * from processlist_as_root; |
does not show all connections, even though the view is SQL SECURITY DEFINER so it should show processlist under root privileges.
Same problem for I_S.TABLES, I_S.SCHEMATA, etc.
Attachments
Issue Links
- includes
-
MDEV-8545 Security definer views don't work with engine's privilege checks
- Closed