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

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 79de984) | patch
Use has_privs_for_roles for predefined role checks
2022年3月28日 19:10:04 +0000 (15:10 -0400)
2022年3月28日 19:10:04 +0000 (15:10 -0400)
commit 6198420ad8a72e37f4fe4964616b17e0fd33b808
Use has_privs_for_roles for predefined role checks

Generally if a role is granted membership to another role with NOINHERIT
they must use SET ROLE to access the privileges of that role, however
with predefined roles the membership and privilege is conflated. Fix that
by replacing is_member_of_role with has_privs_for_role for predefined
roles. Patch does not remove is_member_of_role from acl.h, but it does
add a warning not to use that function for privilege checking. Not
backpatched based on hackers list discussion.

Author: Joshua Brindle
Reviewed-by: Stephen Frost, Nathan Bossart, Joe Conway
Discussion: https://postgr.es/m/flat/CAGB+Vh4Zv_TvKt2tv3QNS6tUM_F_9icmuj0zjywwcgVi4PAhFA@mail.gmail.com
23 files changed:
contrib/adminpack/adminpack.c diff | blob | blame | history
contrib/file_fdw/expected/file_fdw.out diff | blob | blame | history
contrib/file_fdw/file_fdw.c diff | blob | blame | history
contrib/pg_stat_statements/pg_stat_statements.c diff | blob | blame | history
contrib/pgrowlocks/pgrowlocks.c diff | blob | blame | history
doc/src/sgml/adminpack.sgml diff | blob | blame | history
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/func.sgml diff | blob | blame | history
doc/src/sgml/monitoring.sgml diff | blob | blame | history
doc/src/sgml/pgbuffercache.sgml diff | blob | blame | history
doc/src/sgml/pgfreespacemap.sgml diff | blob | blame | history
doc/src/sgml/pgrowlocks.sgml diff | blob | blame | history
doc/src/sgml/pgstatstatements.sgml diff | blob | blame | history
doc/src/sgml/pgvisibility.sgml diff | blob | blame | history
src/backend/commands/copy.c diff | blob | blame | history
src/backend/replication/walreceiver.c diff | blob | blame | history
src/backend/replication/walsender.c diff | blob | blame | history
src/backend/utils/adt/acl.c diff | blob | blame | history
src/backend/utils/adt/dbsize.c diff | blob | blame | history
src/backend/utils/adt/genfile.c diff | blob | blame | history
src/backend/utils/adt/pgstatfuncs.c diff | blob | blame | history
src/backend/utils/misc/guc.c diff | blob | blame | history
src/test/modules/unsafe_tests/expected/rolenames.out diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

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