Re: session_user different from current_user after normal login - Mailing list pgsql-general

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.klaver@aklaver.com