Re: SYSTEM_USER reserved word implementation

Joe Conway <mail@joeconway.com> writes:
> On 6/22/22 10:51, Tom Lane wrote:
>> My immediate guess would be that the SQL committee only intends
>> to deal in SQL role names and therefore SYSTEM_USER is defined
>> to return one of those, but I've not gone looking in the spec
>> to be sure.

> I only have a draft copy, but in SQL 2016 I find relatively thin 
> documentation for what SYSTEM_USER is supposed to represent:

>    The value specified by SYSTEM_USER is equal to an
>    implementation-defined string that represents the
>    operating system user who executed the SQL-client
>    module that contains the externally-invoked procedure
>    whose execution caused the SYSTEM_USER <general value
>    specification> to be evaluated.

Huh.  Okay, if it's implementation-defined then we can define it
as "whatever auth.c put into authn_id".  Objection withdrawn.

            regards, tom lane