Re: RES: session_user different from current_user after normal login

On 11/17/22 13:26, Murillo corvino rocha wrote:
> I am just logging in (using psql) and doing the select: SELECT 
> session_user, current_user;
> 
> The PostgreSQL is an AWS RDS 12.12 instance. No script is being 
> executed. No one besides me is connected to the database. Could it be 
> any server level configuration? I’m pretty sure that few configurations 
> were made to this database.

Is there a psqlrc file that has SET ROLE group_read_only;?

See the:

Files

psqlrc and ~/.psqlrc

section here:

https://www.postgresql.org/docs/current/app-psql.html

for more information.

> 
> Murillo.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com