diff options
| author | Tom Lane | 2018-12-11 16:21:36 +0000 |
|---|---|---|
| committer | Tom Lane | 2018-12-11 16:22:28 +0000 |
| commit | a96722938ed75401c608c7a2487f3591c7915657 (patch) | |
| tree | ed134d78290306aae0988c946a7031be15ccec56 | |
| parent | 3af726a1f3bfccd0db3ea15c72e2df4943a17180 (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 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> |