Postgres Pro
Downloads
Home   >   mailing lists

Thread: getting the OS user name

getting the OS user name

From
John Fabiani
Date:
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.  

Johnf

Re: getting the OS user name

From
Andreas Kretschmer
Date:
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.  

Since you can login to an remote database server: no.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: getting the OS user name

From
John Fabiani
Date:
On Monday, April 23, 2012 04:52:25 PM Andreas Kretschmer wrote:
> 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.
> 
> Since you can login to an remote database server: no.
> 
> 
> Andreas

Ahhh! never considered that issue.

Thanks
Johnf

Re: getting the OS user name

From
Jasen Betts
Date:
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