{"capability":{"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"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},"selected_version":"18"}