From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Alvaro Herrera <alvherre@alvh.no-ip.org>,
        Laurenz Albe <laurenz.albe@cybertec.at>, gparc@free.fr,
        Daniel Gustafsson <daniel@yesql.se>,
        pgsql-docs <pgsql-docs@lists.postgresql.org>
Subject: Re: SQL command : ALTER DATABASE OWNER TO
In-reply-to: 
 <CAKFQuwbFrbdOWCNDgE49RRh07sTAuRODPR0BV1=-nVA01rFFrg@mail.gmail.com>
References: <ae2b506af55afec6f3841d69c1f01aea976df619.camel@cybertec.at>
 <202401241656.hbks4btwvjnf@alvherre.pgsql>
 <CAKFQuwbFrbdOWCNDgE49RRh07sTAuRODPR0BV1=-nVA01rFFrg@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Wed, 24 Jan 2024 10:02:31 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <167866.1706116393.1@sss.pgh.pa.us>
Date: Wed, 24 Jan 2024 12:13:13 -0500
Message-ID: <167867.1706116393@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/167867.1706116393%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> postgres=# grant all on database newdb2 to testowner;
> -- as I am logged in as davidj this grant should actually happen, with
> davidj as the grantor
> -- the grants that materialize from ownership has the owning role as the
> grantor

Yes.  The FM points out somewhere that if a superuser does a GRANT,
it's executed as though by the object owner.  That provision predates
when we supported explicit GRANTED BY clauses in GRANT.  I'm not sure
we'd have made it work like that if we had GRANTED BY already, but
I'm afraid of the compatibility implications if we change it now.

			regards, tom lane