Postgres Pro
Downloads
Home   >   mailing lists

Re: getting the OS user name - Mailing list pgsql-sql

From Jasen Betts
Subject Re: getting the OS user name
Date
Msg-id jn5ssi$9qr$1@reversiblemaps.ath.cx
Whole thread Raw
In response to getting the OS user name  (John Fabiani <johnf@jfcomputer.com>)
List pgsql-sql
Tree view 
On 2012-04-23, John Fabiani <johnf@jfcomputer.com> wrote:
> Hi,
> In my app it is possible to login as one name and use a different name to 
> login to postgres.
>
> Is it possible to get the actual OS login name using plsql.  

not a chance.


RFC1413

man 3 ident

looks like the parameters you need can be found here

http://www.postgresql.org/docs/current/static/functions-info.html

dunno if you can do ident calls from any of the available PLs other
than PLC

RFC1413 can be forged 

-- 
⚂⚃ 100% natural

pgsql-sql by date:

Previous
From: John Fabiani
Date:
Subject: Re: getting the OS user name
Next
From: Emi Lu
Date:
Subject: Simple way to get missing number