RES: session_user different from current_user after normal login

I am just logging in (using psql) and doing the select: SELECT session_user, current_user;

The PostgreSQL is an AWS RDS 12.12 instance. No script is being executed. No one besides me is connected to the database. Could it be any server level configuration? I’m pretty sure that few configurations were made to this database.

Murillo.

De: Adrian Klaver<mailto:adrian(dot)klaver(at)aklaver(dot)com>
Enviado:quinta-feira, 17 de novembro de 2022 14:35
Para: Murillo corvino rocha<mailto:murillo_corvinorocha(at)hotmail(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org<mailto:pgsql-general(at)lists(dot)postgresql(dot)org>
Assunto: Re: session_user different from current_user after normal login

On 11/17/22 07:11, Murillo corvino rocha wrote:
> Hi,
>
> We have a situation where two users are members of a group, like below:
>

> Following the solution in the discussion above, we solved our problem
> using the command:
>
> SET SESSION AUTHORIZATION <username>;
>
> For our example:
>
> SET SESSION AUTHORIZATION user1;
>
> After that, it was possible to change the user password.
>
> My question is: is that a normal behavior? should I, after a normal
> loggin, be logged as
>
> group_read_only as my current_user?

Something or someone is doing SET ROLE group_read_only.

>
> Thanks in advance.
>
> Murillo.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com