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
Murillo corvino rocha writes:
> \drds
> List of settings
> Role| Database | Settings
> --+--+---
> user1| mydb | role=group_read_only
Yeah, that would explain it ... what applied
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
Murillo corvino rocha writes:
> 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
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
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 configuration
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 con