Re: SYSTEM_USER reserved word implementation - Mailing list pgsql-hackers

From Joe Conway
Subject Re: SYSTEM_USER reserved word implementation
Date
Msg-id 28b4a9ef-5103-f117-99e1-99ae5a86a6e8@joeconway.com
Whole thread Raw
In response to Re: SYSTEM_USER reserved word implementation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SYSTEM_USER reserved word implementation
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg15b1: FailedAssertion("val > base", File: "...src/include/utils/relptr.h", Line: 67, PID: 30485)
Next
From: Justin Pryzby
Date:
Subject: ALTER TABLE uses a bistate but not for toast tables