Horton

Re: SYSTEM_USER reserved word implementation

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Drouvot, Bertrand" <bdrouvot@amazon.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-06-22T13:49:17Z
Lists: pgsql-hackers 
"Drouvot, Bertrand" <bdrouvot@amazon.com> writes:
> Please find attached a patch proposal to make use of the SYSTEM_USER so 
> that it returns the authenticated identity (if any) (aka authn_id in the 
> Port struct).

On what grounds do you argue that that's the appropriate meaning of
SYSTEM_USER?

			regards, tom lane

Commits

  1. Introduce SYSTEM_USER

  2. Add some information about authenticated identity via log_connections