diff options
| author | Nathan Bossart <nathan@postgresql.org> | 2024-03-13 14:49:26 -0500 |
|---|---|---|
| committer | Nathan Bossart <nathan@postgresql.org> | 2024-03-13 14:49:26 -0500 |
| commit | ecb0fd33720fab91df1207e85704f382f55e1eb7 (patch) | |
| tree | fa83d8722e9714510a7331664290d79f3a4075f7 /src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm | |
| parent | 2041bc4276c95ac014510032e622a4baf70b29f1 (diff) | |
| download | postgresql-ecb0fd33720fab91df1207e85704f382f55e1eb7.tar.gz postgresql-ecb0fd33720fab91df1207e85704f382f55e1eb7.zip | |
Reintroduce MAINTAIN privilege and pg_maintain predefined role.
Roles with MAINTAIN on a relation may run VACUUM, ANALYZE, REINDEX,
REFRESH MATERIALIZE VIEW, CLUSTER, and LOCK TABLE on the relation.
Roles with privileges of pg_maintain may run those same commands on
all relations.
This was previously committed for v16, but it was reverted in
commit 151c22deee due to concerns about search_path tricks that
could be used to escalate privileges to the table owner. Commits
2af07e2f74, 59825d1639, and c7ea3f4229 resolved these concerns by
restricting search_path when running maintenance commands.
Bumps catversion.
Reviewed-by: Jeff Davis
Discussion: https://postgr.es/m/20240305161235.GA3478007%40nathanxps13
Diffstat (limited to 'src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm')
| -rw-r--r-- | src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm b/src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm index 5be918229e5..3cec72d9d4f 100644 --- a/src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm +++ b/src/test/perl/PostgreSQL/Test/AdjustUpgrade.pm @@ -300,6 +300,17 @@ sub adjust_old_dumpfile $dump = _mash_view_qualifiers($dump); } + if ($old_version >= 14 && $old_version < 17) + { + # Fix up some privilege-set discrepancies. + $dump =~ + s {^REVOKE SELECT,INSERT,REFERENCES,DELETE,TRIGGER,TRUNCATE,UPDATE ON TABLE} + {REVOKE ALL ON TABLE}mg; + $dump =~ + s {^(GRANT SELECT,INSERT,REFERENCES,TRIGGER,TRUNCATE),UPDATE ON TABLE} + {$1,MAINTAIN,UPDATE ON TABLE}mg; + } + if ($old_version < 14) { # Remove mentions of extended hash functions. |