RES: RES: session_user different from current_user after normal login

2022-11-19 Thread Murillo corvino rocha
Could it be the role=group_read_only? The fact that user1 is a member of group_read_only is changing current_user variable? I’m using a clean psql docker container everytime I need to connect to the database, so, I don’t think it’s related to psql. \drds List of settings R

Re: RES: RES: session_user different from current_user after normal login

2022-11-18 Thread Tom Lane
Murillo corvino rocha writes: > \drds > List of settings > Role| Database | Settings > --+--+--- > user1| mydb | role=group_read_only Yeah, that would explain it ... what applied

Re: RES: RES: session_user different from current_user after normal login

2022-11-18 Thread Adrian Klaver
On 11/18/22 12:52, Murillo corvino rocha wrote: Could it be the role=group_read_only? The fact that user1 is a member of group_read_only is changing current_user variable? Well role=group_read_only means this: psql -d database -h host -U user1 effectively becomes: psql -d dat