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:20 -0500 |
| commit | 733f3588cd5c6fe92fdfb7ca088372ec4ddaa60e (patch) | |
| tree | 79799f9f41c346c1697cf1fa14eff9948d9de4a4 | |
| parent | 552c310ba4ec072a2df48a08722f0af2e3703fdf (diff) | |
| download | postgresql-733f3588cd5c6fe92fdfb7ca088372ec4ddaa60e.tar.gz postgresql-733f3588cd5c6fe92fdfb7ca088372ec4ddaa60e.zip | |
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> |