Re: SQL command : ALTER DATABASE OWNER TO - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: SQL command : ALTER DATABASE OWNER TO
Date
Msg-id ae2b506af55afec6f3841d69c1f01aea976df619.camel@cybertec.at
Whole thread Raw
In response to Re: SQL command : ALTER DATABASE OWNER TO  (gparc@free.fr)
Responses Re: SQL command : ALTER DATABASE OWNER TO
Re: SQL command : ALTER DATABASE OWNER TO
Re: SQL command : ALTER DATABASE OWNER TO
List pgsql-docs
On Wed, 2024-01-24 at 15:40 +0100, gparc@free.fr wrote:
> maybe a misunderstanding of my part, but your proposed modification doesn't matched
> with the current behaviour of the command as precisely the object privileges of the old owner are **NOT** transferred
> to the new owner along with the ownership

But that is what happens.

The permissions are transferred to the new owner, so the old owner doesn't
have any privileges on the object (and, in your case, cannot connect to
the database any more).

Yours,
Laurenz Albe



pgsql-docs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Incorrect grammar on ALTER EVENT TRIGGER
Next
From: Alvaro Herrera
Date:
Subject: Re: Spam complaint