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@xxxxxxxxxxx
