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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c6f6646) | patch
Add grantable MAINTAIN privilege and pg_maintain role.
2022年12月14日 01:33:28 +0000 (17:33 -0800)
2022年12月14日 01:33:28 +0000 (17:33 -0800)
commit 60684dd834a222fefedd49b19d1f0a6189c1632e
Add grantable MAINTAIN privilege and pg_maintain role.

Allows VACUUM, ANALYZE, REINDEX, REFRESH MATERIALIZED VIEW, CLUSTER,
and LOCK TABLE.

Effectively reverts 4441fc704d. Instead of creating separate
privileges for VACUUM, ANALYZE, and other maintenance commands, group
them together under a single MAINTAIN privilege.

Author: Nathan Bossart
Discussion: https://postgr.es/m/20221212210136.GA449764@nathanxps13
Discussion: https://postgr.es/m/45224.1670476523@sss.pgh.pa.us
36 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/cluster.sgml diff | blob | blame | history
doc/src/sgml/ref/grant.sgml diff | blob | blame | history
doc/src/sgml/ref/lock.sgml diff | blob | blame | history
doc/src/sgml/ref/refresh_materialized_view.sgml diff | blob | blame | history
doc/src/sgml/ref/reindex.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
doc/src/sgml/user-manag.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/cluster.c diff | blob | blame | history
src/backend/commands/indexcmds.c diff | blob | blame | history
src/backend/commands/lockcmds.c diff | blob | blame | history
src/backend/commands/matview.c diff | blob | blame | history
src/backend/commands/tablecmds.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/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_authid.dat diff | blob | blame | history
src/include/commands/tablecmds.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
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /