summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Gustafsson2025-11-12 16:04:35 +0000
committerDaniel Gustafsson2025-11-12 16:04:35 +0000
commitd36acd6f5c924bfe6a8618df49512cf05f898324 (patch)
treee31197333c9141f90670df6490e54204aa3e909d
parent877a024902a73732d9f976804aee9699dcbe1d90 (diff)
doc: Document effects of ownership change on privilegesHEADmaster
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 <[email protected]> Reviewed-by: Daniel Gustafsson <[email protected]> Reviewed-by: David G. Johnston <[email protected]> Reviewed-by: Tom Lane <[email protected]> Reviewed-by: Josef Šimánek <[email protected]> Reported-by: Gilles Parc <[email protected]> Discussion: https://postgr.es/m/2023185982.281851219.1646733038464.JavaMail.root@zimbra15-e2.priv.proxad.net Backpatch-through: 14
-rw-r--r--doc/src/sgml/ddl.sgml2
1 files changed, 2 insertions, 0 deletions
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 <replaceable>table_name</replaceable> OWNER TO <replaceable>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 <literal>SET ROLE</literal> to the new owning role.
+ All object privileges of the old owner are transferred to the new owner
+ along with the ownership.
</para>
<para>