Re: RES: session_user different from current_user after normal login - Mailing list pgsql-general

From Adrian Klaver
Subject Re: RES: session_user different from current_user after normal login
Date
Msg-id 679be34a-7476-c7e1-30a6-2f5dcaf549b5@aklaver.com
Whole thread Raw
In response to session_user different from current_user after normal login  (Murillo corvino rocha <murillo_corvinorocha@hotmail.com>)
Responses RES: session_user different from current_user after normal login  (Murillo corvino rocha <murillo_corvinorocha@hotmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Alejandro Baeza Rangel
Date:
Subject: Duda sobre como imprimir un campo INTERVAL
Next
From: David Gauthier
Date:
Subject: Drop role cascade ?