dbTalk Databases Forums  

[SQL] getting the OS user name

mailing.database.pgsql-sql mailing.database.pgsql-sql


Discuss [SQL] getting the OS user name in the mailing.database.pgsql-sql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
John Fabiani
 
Posts: n/a

Default [SQL] getting the OS user name - 04-23-2012 , 09:28 AM






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

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

Reply With Quote
  #2  
Old   
Andreas Kretschmer
 
Posts: n/a

Default Re: [SQL] getting the OS user name - 04-23-2012 , 09:52 AM






John Fabiani <johnf (AT) jfcomputer (DOT) com> wrote:

Quote:
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°

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

Reply With Quote
  #3  
Old   
John Fabiani
 
Posts: n/a

Default Re: [SQL] getting the OS user name - 04-23-2012 , 09:57 AM



On Monday, April 23, 2012 04:52:25 PM Andreas Kretschmer wrote:
Quote:
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.

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


Andreas
Ahhh! never considered that issue.

Thanks
Johnf

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

Reply With Quote
  #4  
Old   
Jasen Betts
 
Posts: n/a

Default Re: [SQL] getting the OS user name - 04-24-2012 , 04:48 AM



On 2012-04-23, John Fabiani <johnf (AT) jfcomputer (DOT) com> wrote:
Quote:
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/curre...ions-info.html

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

RFC1413 can be forged

--
⚂⚃ 100% natural


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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.