projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 1f059a4) | patch
Provide per-table permissions for vacuum and analyze.
authorAndrew Dunstan <andrew@dunslane.net>
Mon, 28 Nov 2022 15:08:42 +0000 (10:08 -0500)
committerAndrew Dunstan <andrew@dunslane.net>
Mon, 28 Nov 2022 17:08:14 +0000 (12:08 -0500)
commitb5d6382496f2b8fc31abd92c2654a9a67aca76c6
tree2f9521bf4654a1643f7987b1dbc1247b81283ff3tree
parent1f059a440864021b23b0667e7c0cb664710b660dcommit | diff
Provide per-table permissions for vacuum and analyze.

Currently a table can only be vacuumed or analyzed by its owner or
a superuser. This can now be extended to any user by means of an
appropriate GRANT.

Nathan Bossart

Reviewed by: Bharath Rupireddy, Kyotaro Horiguchi, Stephen Frost, Robert
Haas, Mark Dilger, Tom Lane, Corey Huinker, David G. Johnston, Michael
Paquier.

Discussion: https://postgr.es/m/20220722203735.GB3996698@nathanxps13
24 files changed:
doc/src/sgml/ddl.sgml diff | blob | blame | history
doc/src/sgml/func.sgml diff | blob | blame | history
doc/src/sgml/ref/alter_default_privileges.sgml diff | blob | blame | history
doc/src/sgml/ref/analyze.sgml diff | blob | blame | history
doc/src/sgml/ref/grant.sgml diff | blob | blame | history
doc/src/sgml/ref/revoke.sgml diff | blob | blame | history
doc/src/sgml/ref/vacuum.sgml diff | blob | blame | history
src/backend/catalog/aclchk.c diff | blob | blame | history
src/backend/commands/analyze.c diff | blob | blame | history
src/backend/commands/vacuum.c diff | blob | blame | history
src/backend/parser/gram.y diff | blob | blame | history
src/backend/utils/adt/acl.c diff | blob | blame | history
src/bin/pg_dump/dumputils.c diff | blob | blame | history
src/bin/pg_dump/t/002_pg_dump.pl diff | blob | blame | history
src/bin/psql/tab-complete.c diff | blob | blame | history
src/include/commands/vacuum.h diff | blob | blame | history
src/include/nodes/parsenodes.h diff | blob | blame | history
src/include/utils/acl.h diff | blob | blame | history
src/test/regress/expected/dependency.out diff | blob | blame | history
src/test/regress/expected/privileges.out diff | blob | blame | history
src/test/regress/expected/rowsecurity.out diff | blob | blame | history
src/test/regress/expected/vacuum.out diff | blob | blame | history
src/test/regress/sql/dependency.sql diff | blob | blame | history
src/test/regress/sql/privileges.sql diff | blob | blame | history
Robert Haas's development tree.