From d36acd6f5c924bfe6a8618df49512cf05f898324 Mon Sep 17 00:00:00 2001 From: Daniel Gustafsson Date: Wed, 12 Nov 2025 17:04:35 +0100 Subject: doc: Document effects of ownership change on privileges Explicitly document that privileges are transferred along with the ownership. Backpatch to all supported versions since this behavior has always been present. Author: Laurenz Albe Reviewed-by: Daniel Gustafsson Reviewed-by: David G. Johnston Reviewed-by: Tom Lane Reviewed-by: Josef Šimánek Reported-by: Gilles Parc Discussion: https://postgr.es/m/2023185982.281851219.1646733038464.JavaMail.root@zimbra15-e2.priv.proxad.net Backpatch-through: 14 --- doc/src/sgml/ddl.sgml | 2 ++ 1 file changed, 2 insertions(+) diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index 948b9327f24..bf574a1741b 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -2251,6 +2251,8 @@ ALTER TABLE table_name OWNER TO new_owne Superusers can always do this; ordinary roles can only do it if they are both the current owner of the object (or inherit the privileges of the owning role) and able to SET ROLE to the new owning role. + All object privileges of the old owner are transferred to the new owner + along with the ownership. -- cgit v1.2.3