SECURITY INVOKER views
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.
Views & Materialized Views
Description
Views can be created using the SECURITY INVOKER parameter, which executes the view with the privileges of the caller instead of the privileges of the owner.
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 389
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "security-invoker-views",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "SECURITY INVOKER views",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "SECURITY INVOKER views",
"NameLocale": "en",
"GroupKey": "views-materialized-views",
"GroupName": "Views \u0026 Materialized Views",
"GroupLocale": "en",
"Ordinal": 2,
"GroupOrder": 8,
"Facts": {
"feature": {
"description": "[Views](https://www.postgresql.org/docs/15/sql-createview.html) can be created using the `SECURITY INVOKER` parameter, which executes the view with the privileges of the caller instead of the privileges of the owner.",
"name": "SECURITY INVOKER views",
"versions": {
"15": "Yes"
}
},
"group": "Views \u0026 Materialized Views",
"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": "SECURITY INVOKER views",
"BodyHTML": "\u003cp\u003e\u003ca href=\"https://www.postgresql.org/docs/15/sql-createview.html\" rel=\"nofollow\"\u003eViews\u003c/a\u003e can be created using the \u003ccode\u003eSECURITY INVOKER\u003c/code\u003e parameter, which executes the view with the privileges of the caller instead of the privileges of the owner.\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "9c8c720cf70920ad1c9131a6393be02bee61b5778574c86f6e50d11a242dc5d8",
"Payload": {
"description": "[Views](https://www.postgresql.org/docs/15/sql-createview.html) can be created using the `SECURITY INVOKER` parameter, which executes the view with the privileges of the caller instead of the privileges of the owner.",
"name": "SECURITY INVOKER views",
"versions": {
"15": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "SECURITY INVOKER 视图",
"BodyHTML": "\u003cp\u003e视图现在可以使用 \u003ccode\u003eSECURITY INVOKER\u003c/code\u003e 创建，以调用者而非视图所有者的权限执行。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "1d7bfb85fbc3dc4b7f84c38ec8cfb3f9c7c9ef5b2be0411d0f4d09b8e95e35fd",
"Payload": {
"description": "视图现在可以使用 `SECURITY INVOKER` 创建，以调用者而非视图所有者的权限执行。",
"name": "SECURITY INVOKER 视图"
}
}
],
"GroupTitles": {
"en": "Views \u0026 Materialized Views",
"zh-Hans": "视图和物化视图"
},
"LegacyIDs": [
"389"
]
}