aboutsummaryrefslogtreecommitdiff
path: root/src/backend
diff options
context:
space:
mode:
authorNoah Misch <noah@leadboat.com>2023-11-06 06:14:13 -0800
committerNoah Misch <noah@leadboat.com>2023-11-06 06:14:16 -0800
commit2c3c5ec4936a6f20354766612ebd650abbb17817 (patch)
tree5c1b7ab469c908edb3188e5d81a0d5bf3efbc83e /src/backend
parent78541273156c74ed20acdc141cf2f996098cd794 (diff)
downloadpostgresql-2c3c5ec4936a6f20354766612ebd650abbb17817.tar.gz
postgresql-2c3c5ec4936a6f20354766612ebd650abbb17817.zip
Set GUC "is_superuser" in all processes that set AuthenticatedUserId.
It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch to v11 (all supported versions). Jelte Fennema-Nio. Reported by Jelte Fennema-Nio.
Diffstat (limited to 'src/backend')
-rw-r--r--src/backend/utils/init/miscinit.c8
1 files changed, 8 insertions, 0 deletions
diff --git a/src/backend/utils/init/miscinit.c b/src/backend/utils/init/miscinit.c
index a604432126c..0e4942578bf 100644
--- a/src/backend/utils/init/miscinit.c
+++ b/src/backend/utils/init/miscinit.c
@@ -844,6 +844,14 @@ InitializeSessionUserIdStandalone(void)
AuthenticatedUserIsSuperuser = true;
SetSessionUserId(BOOTSTRAP_SUPERUSERID, true);
+
+ /*
+ * XXX This should set SetConfigOption("session_authorization"), too.
+ * Since we don't, C code will get NULL, and current_setting() will get an
+ * empty string.
+ */
+ SetConfigOption("is_superuser", "on",
+ PGC_INTERNAL, PGC_S_DYNAMIC_DEFAULT);
}
/*