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



Reply via email to