On 6/22/22 09:49, Tom Lane wrote:
> "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?
What else do you imagine it might mean?
Here is SQL Server interpretation for example:
https://docs.microsoft.com/en-us/sql/t-sql/functions/system-user-transact-sql?view=sql-server-ver16
And Oracle:
http://luna-ext.di.fc.ul.pt/oracle11g/timesten.112/e13070/ttsql257.htm#i1120532
"SYSTEM_USER
Returns the name of the current data store user
as identified by the operating system."
Seems equivalent.
--
Joe Conway
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
