public inbox for [email protected]
help / color / mirror / Atom feedFrom: Peter J. Holzer <[email protected]>
To: [email protected]
Subject: Re: set role command
Date: Fri, 28 Nov 2025 22:41:40 +0100
Message-ID: <tquqmtevx6v7lzxlifznrisnlnfoc5u44fbpltkupfj2ay6dve@xdovetnlvk7h> (raw)
In-Reply-To: <[email protected]>
References: <CA+bysH_or91tt7r0gKLJtw5Wp+DEYwnaRJoTvLfKO33dcdQ_rQ@mail.gmail.com>
<[email protected]>
On 2025-11-24 17:30:14 -0500, [email protected] wrote:
> Just because you did set role does not mean you lost your superuser privileges,
> it's correct behavior.
>
> If you want to impersonate in a permissions sandbox it's easy:
>
> create role usera_sandbox in group usera;
> \c - usera_sandbox
But that just disconnects and reconnects as the new user. So you have to
be able to authenticate as that user.
hjp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
Attachments:
[application/pgp-signature] signature.asc (833B, 2-signature.asc)
download
view thread (4+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: set role command
In-Reply-To: <tquqmtevx6v7lzxlifznrisnlnfoc5u44fbpltkupfj2ay6dve@xdovetnlvk7h>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox