Re: Need linux uid in pg-psql

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alan Hodgson <ahodgson(at)simkin(dot)ca>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need linux uid in pg-psql
Date: 2011-08-19 16:07:41
Message-ID: 482E80323A35A54498B8B70FF2B8798004CFB01777@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not too worried about nefarious id faking in this environment.
How does one use "identd" in an unobscured way?

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Friday, August 19, 2011 11:55 AM
To: Alan Hodgson
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Need linux uid in pg-psql

Alan Hodgson <ahodgson(at)simkin(dot)ca> writes:
> On August 19, 2011 07:01:33 AM Gauthier, Dave wrote:
>> Is there a way to get the linux idsid of a user, even for a remote network
>> connection?

> There's an identd protocol for this. It's not commonly used anymore, and when
> present tends to deliberately obscure the results.

Not to mention that it's trivially faked, if the user has root on his
own machine.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent de Phily 2011-08-19 16:09:25 Re: altering foreign key without a table scan
Previous Message Tom Lane 2011-08-19 15:58:19 Re: date_trunc - not sure what is wrong, but it confuses me.