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 previledge.
Precisely. That's why you don't connect as a superuser, unless you
need to for administrative purposes.
Yours,
Laurenz Albe