git.ipfire.org Git - thirdparty/postgresql.git/commit

]> git.ipfire.org Git - thirdparty/postgresql.git/commit

projects / thirdparty / postgresql.git / commit

author	Andrew Dunstan <andrew@dunslane.net>
	Mon, 28 Nov 2022 15:08:42 +0000 (10:08 -0500)
committer	Andrew Dunstan <andrew@dunslane.net>
	Mon, 28 Nov 2022 17:08:14 +0000 (12:08 -0500)
commit	b5d6382496f2b8fc31abd92c2654a9a67aca76c6
tree	2f9521bf4654a1643f7987b1dbc1247b81283ff3	tree \| snapshot
parent	1f059a440864021b23b0667e7c0cb664710b660d	commit \| 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

Mirror of https://git.postgresql.org/git/postgresql.git

RSS Atom