Message-ID: <916918a4bb3461ae62aed8f01f997d86743d7f53.camel@cybertec.at>
Subject: Re: set role command
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Calvin Guo <newoakllc2023@gmail.com>, pg254kl@georgiou.vip
Cc: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: Thu, 27 Nov 2025 07:56:46 +0100
In-Reply-To: <CA+bysH86U8QRX+HWSRQTNdY8mu5i_qOFy1OF9-spenWCOtngaw@mail.gmail.com>
References: 
	<CA+bysH_or91tt7r0gKLJtw5Wp+DEYwnaRJoTvLfKO33dcdQ_rQ@mail.gmail.com>
	 <176402341688.7.8547269556353940402.1025478372@georgiou.vip>
	 <CA+bysH86U8QRX+HWSRQTNdY8mu5i_qOFy1OF9-spenWCOtngaw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.56.2 (3.56.2-2.fc42) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/916918a4bb3461ae62aed8f01f997d86743d7f53.camel%40cybertec.at>
Precedence: bulk

On Thu, 2025-11-27 at 14:25 +0800, Calvin Guo wrote:
> create role usera_sandbox in group usera;
> \c - usera_sandbox
> but what will happen if I then issue:
> reset role?

Nothing will happen.

\c disconnects the superuser session and establishes a new connection,
so there is nothing to reset to.

> Seems like once I connect as a super user, there is no way for drop the p=
reviledge.

Precisely.  That's why you don't connect as a superuser, unless you
need to for administrative purposes.

Yours,
Laurenz Albe