Privileges for setting configuration parameters
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
Security
Description
Unprivileged users can be granted permission to change server variables via SET and ALTER SYSTEM
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 390
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "privileges-for-setting-configuration-parameters",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "Privileges for setting configuration parameters",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "Privileges for setting configuration parameters",
"NameLocale": "en",
"GroupKey": "security",
"GroupName": "Security",
"GroupLocale": "en",
"Ordinal": 20,
"GroupOrder": 14,
"Facts": {
"feature": {
"description": "Unprivileged users can be [granted permission](https://www.postgresql.org/docs/15/sql-grant.html) to change server variables via [`SET`](https://www.postgresql.org/docs/current/sql-set.html) and [`ALTER SYSTEM`](https://www.postgresql.org/docs/current/sql-altersystem.html)",
"name": "Privileges for setting configuration parameters",
"versions": {
"15": "Yes"
}
},
"group": "Security",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "Privileges for setting configuration parameters",
"BodyHTML": "\u003cp\u003eUnprivileged users can be \u003ca href=\"https://www.postgresql.org/docs/15/sql-grant.html\" rel=\"nofollow\"\u003egranted permission\u003c/a\u003e to change server variables via \u003ca href=\"https://www.postgresql.org/docs/current/sql-set.html\" rel=\"nofollow\"\u003e\u003ccode\u003eSET\u003c/code\u003e\u003c/a\u003e and \u003ca href=\"https://www.postgresql.org/docs/current/sql-altersystem.html\" rel=\"nofollow\"\u003e\u003ccode\u003eALTER SYSTEM\u003c/code\u003e\u003c/a\u003e\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "61e2a227452fb220aecc07088d58a41127c74f582594023b3c471889fd3dd9e0",
"Payload": {
"description": "Unprivileged users can be [granted permission](https://www.postgresql.org/docs/15/sql-grant.html) to change server variables via [`SET`](https://www.postgresql.org/docs/current/sql-set.html) and [`ALTER SYSTEM`](https://www.postgresql.org/docs/current/sql-altersystem.html)",
"name": "Privileges for setting configuration parameters",
"versions": {
"15": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "设置配置参数的权限",
"BodyHTML": "\u003cp\u003e非特权用户现在可以被授予通过 \u003ccode\u003eSET\u003c/code\u003e 修改服务器配置参数的权限。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "252dc9d726c93be4675dc3d9ad745062be4923e227def64c801e5d3dd89edd73",
"Payload": {
"description": "非特权用户现在可以被授予通过 `SET` 修改服务器配置参数的权限。",
"name": "设置配置参数的权限"
}
}
],
"GroupTitles": {
"en": "Security",
"zh-Hans": "安全"
},
"LegacyIDs": [
"390"
]
}