Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit d65ddb2

Browse filesBrowse files
committed
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
1 parent 1db439a commit d65ddb2
Copy full SHA for d65ddb2

File tree

1 file changed

+9
-3
lines changed
Filter options

1 file changed

+9
-3
lines changed

‎doc/src/sgml/ref/alter_large_object.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/ref/alter_large_object.sgml
+9-3Lines changed: 9 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -30,9 +30,15 @@ ALTER LARGE OBJECT <replaceable class="parameter">large_object_oid</replaceable>
3030

3131
<para>
3232
<command>ALTER LARGE OBJECT</command> changes the definition of a
33-
large object. The only functionality is to assign a new owner.
34-
You must be superuser or owner of the large object to use
35-
<command>ALTER LARGE OBJECT</command>.
33+
large object.
34+
</para>
35+
36+
<para>
37+
You must own the large object to use <command>ALTER LARGE OBJECT</command>.
38+
To alter the owner, you must also be a direct or indirect member of the new
39+
owning role. (However, a superuser can alter any large object anyway.)
40+
Currently, the only functionality is to assign a new owner, so both
41+
restrictions always apply.
3642
</para>
3743
</refsect1>
3844

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.