Re: getting the OS user name

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: getting the OS user name
Date: 2012-04-24 09:48:02
Message-ID: jn5ssi$9qr$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 2012-04-23, John Fabiani <johnf(at)jfcomputer(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2012-04-24 14:15:26 Simple way to get missing number
Previous Message John Fabiani 2012-04-23 14:57:51 Re: getting the OS user name