Re: Need linux uid in pg-psql - Mailing list pgsql-general

From Gauthier, Dave
Subject Re: Need linux uid in pg-psql
Date
Msg-id 482E80323A35A54498B8B70FF2B8798004CFB01777@azsmsx504.amr.corp.intel.com
Whole thread Raw
In response to Re: Need linux uid in pg-psql  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Need linux uid in pg-psql
List 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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tom Lane
Sent: Friday, August 19, 2011 11:55 AM
To: Alan Hodgson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Need linux uid in pg-psql

Alan Hodgson <ahodgson@simkin.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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: date_trunc - not sure what is wrong, but it confuses me.
Next
From: Vincent de Phily
Date:
Subject: Re: altering foreign key without a table scan