Re: RES: session_user different from current_user after normal login

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Murillo corvino rocha <murillo_corvinorocha(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: RES: session_user different from current_user after normal login
Date: 2022-11-17 22:54:46
Message-ID: 679be34a-7476-c7e1-30a6-2f5dcaf549b5@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Gauthier 2022-11-17 23:07:50 Drop role cascade ?
Previous Message Alejandro Baeza Rangel 2022-11-17 22:30:14 Duda sobre como imprimir un campo INTERVAL