postgres.git / summary / log / commit / refs

commit    a96722938ed75401c608c7a2487f3591c7915657
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Tue Dec 11 16:21:36 2018 +0000
First released in: 12.0, 9.4.21, 9.5.16, 9.6.12, 10.7, 11.2

    Doc: improve documentation about ALTER LARGE OBJECT requirements.
    
    Unlike other ALTER ref pages, this one neglected to mention that
    ALTER OWNER requires being a member of the new owning role.
    Per bug #15546 from Stefan Kadow.
    
    Discussion: https://postgr.es/m/15546-0558c75fd2025e7c@postgresql.org


 doc/src/sgml/ref/alter_large_object.sgml | 12 +++++++++---
 1 file changed, 9 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/ref/alter_large_object.sgml b/doc/src/sgml/ref/alter_large_object.sgml
index a6dabca1b2f..49d54ea74ee 100644
--- a/doc/src/sgml/ref/alter_large_object.sgml
+++ b/doc/src/sgml/ref/alter_large_object.sgml
@@ -30,9 +30,15 @@ ALTER LARGE OBJECT <replaceable class="PARAMETER">large_object_oid</replaceable>
 
   <para>
    <command>ALTER LARGE OBJECT</command> changes the definition of a
-   large object. The only functionality is to assign a new owner.
-   You must be superuser or owner of the large object to use
-   <command>ALTER LARGE OBJECT</command>.
+   large object.
+  </para>
+
+  <para>
+   You must own the large object to use <command>ALTER LARGE OBJECT</command>.
+   To alter the owner, you must also be a direct or indirect member of the new
+   owning role.  (However, a superuser can alter any large object anyway.)
+   Currently, the only functionality is to assign a new owner, so both
+   restrictions always apply.
   </para>
  </refsect1>
 


[parent: 3af726a1f3bf]