Re: SYSTEM_USER reserved word implementation

On 6/22/22 09:49, Tom Lane wrote:
> "Drouvot, Bertrand"  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