diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2018-12-11 11:21:36 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2018-12-11 11:22:02 -0500 |
| commit | b10997b5b3eec7fb9fe64d7543435552f327ee51 (patch) | |
| tree | 9afde58d640ad3c60d1a0d90e587d70bcf8a272f | |
| parent | eff12423391637b04b3426db57c5eda93161a0b8 (diff) | |
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
| -rw-r--r-- | doc/src/sgml/ref/alter_large_object.sgml | 12 |
1 files 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 5748d52db11..2e9b7beab00 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> |