pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedgetting the OS user name
4+ messages / 3 participants
[nested] [flat]
* getting the OS user name
@ 2012-04-23 14:28 John Fabiani <johnf@jfcomputer.com>
2012-04-23 14:52 ` Re: getting the OS user name Andreas Kretschmer <akretschmer@spamfence.net>
2012-04-24 09:48 ` Re: getting the OS user name Jasen Betts <jasen@xnet.co.nz>
0 siblings, 2 replies; 4+ messages in thread
From: John Fabiani @ 2012-04-23 14:28 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: getting the OS user name
2012-04-23 14:28 getting the OS user name John Fabiani <johnf@jfcomputer.com>
@ 2012-04-23 14:52 ` Andreas Kretschmer <akretschmer@spamfence.net>
2012-04-23 14:57 ` Re: getting the OS user name John Fabiani <johnf@jfcomputer.com>
1 sibling, 1 reply; 4+ messages in thread
From: Andreas Kretschmer @ 2012-04-23 14:52 UTC (permalink / raw)
To: pgsql-sql
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°
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: getting the OS user name
2012-04-23 14:28 getting the OS user name John Fabiani <johnf@jfcomputer.com>
2012-04-23 14:52 ` Re: getting the OS user name Andreas Kretschmer <akretschmer@spamfence.net>
@ 2012-04-23 14:57 ` John Fabiani <johnf@jfcomputer.com>
0 siblings, 0 replies; 4+ messages in thread
From: John Fabiani @ 2012-04-23 14:57 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: getting the OS user name
2012-04-23 14:28 getting the OS user name John Fabiani <johnf@jfcomputer.com>
@ 2012-04-24 09:48 ` Jasen Betts <jasen@xnet.co.nz>
1 sibling, 0 replies; 4+ messages in thread
From: Jasen Betts @ 2012-04-24 09:48 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2012-04-24 09:48 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-04-23 14:28 getting the OS user name John Fabiani <johnf@jfcomputer.com>
2012-04-23 14:52 ` Andreas Kretschmer <akretschmer@spamfence.net>
2012-04-23 14:57 ` John Fabiani <johnf@jfcomputer.com>
2012-04-24 09:48 ` Jasen Betts <jasen@xnet.co.nz>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox