[MDEV-27124] mariadb-update definer of Add/DropGeometryColumn procedures from 'root' to 'mariadb.sys' Created: 2021-11-25 Updated: 2021-11-26 Resolved: 2021-11-26 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Upgrades |
| Affects Version/s: | 10.4 |
| Fix Version/s: | 10.4.23, 10.5.14, 10.6.6, 10.7.2 |
| Type: | Bug | Priority: | Major |
| Reporter: | Daniel Black | Assignee: | Daniel Black |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
from: https://github.com/MariaDB/server/pull/1936 From 10.4.13, the mariadb.sys user was created to replace root definers. In commit 0253ea7, definer of Add/DropGeometryColumn procedures was changed to mariadb.sys, in scripts/maria_add_gis_sp.sql.in. However, maria_add_gis_sp.sql only applies to new databases created by This commit is to update the definer from root to mariadb.sys during Doesn't choose to execute maria_add_gis_sp.sql in upgrade script to |