Postgres Pro
Downloads
Home   >   mailing lists

Thread: Note addition to REASSIGN OWNED

Note addition to REASSIGN OWNED

From
Josh Berkus
Date:
Need this sentence added in the Notes section of sql-reassign-owned:

REASSIGN OWNED will not reassign the ownership of any databases owned by
the role.  These still need to be changed using ALTER DATABASE.

--
                                   -- Josh Berkus
                                      PostgreSQL Experts Inc.
                                      http://www.pgexperts.com

Re: Note addition to REASSIGN OWNED

From
Alvaro Herrera
Date:
Excerpts from Josh Berkus's message of mié may 05 23:24:44 -0400 2010:
> Need this sentence added in the Notes section of sql-reassign-owned:
>
> REASSIGN OWNED will not reassign the ownership of any databases owned by
> the role.  These still need to be changed using ALTER DATABASE.

I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
OWNED.  Do we really need to fix the docs, or should we fix the code?
--

Re: Note addition to REASSIGN OWNED

From
Bruce Momjian
Date:
Alvaro Herrera wrote:
> Excerpts from Josh Berkus's message of mié may 05 23:24:44 -0400 2010:
> > Need this sentence added in the Notes section of sql-reassign-owned:
> >
> > REASSIGN OWNED will not reassign the ownership of any databases owned by
> > the role.  These still need to be changed using ALTER DATABASE.
>
> I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
> OWNED.  Do we really need to fix the docs, or should we fix the code?

Where are we on this?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +

Re: Note addition to REASSIGN OWNED

From
Alvaro Herrera
Date:
Excerpts from Bruce Momjian's message of lun may 31 13:58:36 -0400 2010:
> Alvaro Herrera wrote:
> > Excerpts from Josh Berkus's message of mi\xc3\xa9 may 05 23:24:44 -0400 2010:
> > > Need this sentence added in the Notes section of sql-reassign-owned:
> > >
> > > REASSIGN OWNED will not reassign the ownership of any databases owned by
> > > the role.  These still need to be changed using ALTER DATABASE.
> >
> > I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
> > OWNED.  Do we really need to fix the docs, or should we fix the code?
>
> Where are we on this?

I just patched the docs, slightly rewording Josh's suggestion.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support