Postgres Pro
Downloads
Home   >   mailing lists

Re: get user info on log - Mailing list pgsql-general

From Marcos Pegoraro
Subject Re: get user info on log
Date
Msg-id CAB-JLwbD7VuzC0geb+=LMR_URA03LqEN3+rWbSgWL+Md498LJA@mail.gmail.com
Whole thread Raw
In response to Re: get user info on log  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: get user info on log
Re: get user info on log
List pgsql-general
Tree view
Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver <adrian.klaver@aklaver.com> escreveu:
test(5432)=# set role maura;
ERROR:  role "maura" does not exist
test(5432)=# SET SESSION AUTHORIZATION 'maura';
ERROR:  role "maura" does not exist

No, I was asking about an error occurring later, not on set session authorization command.

set role maura; 
--user Maura exists and set was done correctly
--now I´m working as Maura
select 1/0; -- I would like to see this exception on log being logged as maura

thanks
Marcos

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re[2]: CVE-2022-2625
Next
From: "Hilbert, Karin"
Date:
Subject: New message in PostgreSQL log regarding socket for statistics collector