Re: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects. - Mailing list pgsql-docs

From Tom Lane
Subject Re: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.
Date
Msg-id 23831.1553546466@sss.pgh.pa.us
Whole thread Raw
In response to REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: REASSIGN OWNED command page is not clear regarding to DEFAULTPRIVILEGE objects.  (Brandon Hsu <brandon.hsu@omniwaresoft.com.tw>)
List pgsql-docs
PG Doc comments form <noreply@postgresql.org> writes:
> Recently I try to drop a role without affecting objects dropped owned by it,
> and try to use REASSIGN OWNED command to transfer ownership.
> But we find DEFAULT PRIVILEGE policies are not transferred.
> ...
> Is it possible to add a note in REASSIGN OWNED page for this behavior?

The REASSIGN OWNED page does mention that it doesn't touch privileges
on non-owned objects, but I agree that it'd be better to be explicit
that that applies to default privileges.  Will fix, thanks for reporting!

            regards, tom lane


pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.
Next
From: Daniel Gustafsson
Date:
Subject: Typo in ECPG documentation