On 9/13/22 12:45, Marcos Pegoraro wrote:
> When using set role or set session authorization and an error occurs I
> get user name which logged in and not the one I´ve changed to.
>
> There is a way to get session_user and current_user on log ?
When I do:
test(5432)=# set role maura;
ERROR: role "maura" does not exist
test(5432)=# SET SESSION AUTHORIZATION 'maura';
ERROR: role "maura" does not exist
I get:
psql-postgres-2022-09-15 08:53:41.204 PDT-0ERROR: role "maura" does not
exist
psql-postgres-2022-09-15 08:53:41.204 PDT-0STATEMENT: set role maura;
psql-postgres-2022-09-15 08:55:26.325 PDT-0ERROR: role "maura" does not
exist
psql-postgres-2022-09-15 08:55:26.325 PDT-0STATEMENT: SET SESSION
AUTHORIZATION 'maura';
in the logs.
Are you not seeing that or do you want something different?
If you want something different then you will need to provide a more
detailed description of what that is.
>
> Thanks
> Marcos
--
Adrian Klaver
adrian.klaver@aklaver.com