RES: RES: session_user different from current_user after normal login

2022-11-19 Thread Murillo corvino rocha
1 Para: Murillo corvino rocha<mailto:murillo_corvinoro...@hotmail.com> Cc:Adrian Klaver<mailto:adrian.kla...@aklaver.com>; pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> Assunto: Re: RES: session_user different from current_user after normal logi

RES: session_user different from current_user after normal login

2022-11-18 Thread Murillo corvino rocha
urillo corvino rocha<mailto:murillo_corvinoro...@hotmail.com>; pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists.postgresql.org> Assunto: Re: RES: session_user different from current_user after normal login On 11/17/22 13:26, Murillo corvino rocha wrote: > I am just loggin

RES: session_user different from current_user after normal login

2022-11-18 Thread Murillo corvino rocha
configurations were made to this database. Murillo. De: Adrian Klaver<mailto:adrian.kla...@aklaver.com> Enviado:quinta-feira, 17 de novembro de 2022 14:35 Para: Murillo corvino rocha<mailto:murillo_corvinoro...@hotmail.com>; pgsql-general@lists.postgresql.org<mailto:pgsql-general@lists

session_user different from current_user after normal login

2022-11-17 Thread Murillo corvino rocha
Hi, We have a situation where two users are members of a group, like below: group_read_only |- user1 |- user2 We tried to change the password for those users, using a query like below: ALTER ROLE user1 PASSWORD 'sup3r$4fe'; but got a "ERROR: permission denied" (using pgadmin4 and psql