pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
User login 2+ messages / 2 participants [nested] [flat]
* User login @ 2008-11-20 12:12 Swathi S <ss.postgres@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Swathi S @ 2008-11-20 12:12 UTC (permalink / raw) To: pgsql-admin Hi, How do we find which user logged in from the OS level in postgres. For eg: If user "a" logged in from the OS level and logged into postgres psql as user "b" .........how do we find the login details? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: User login @ 2008-11-20 16:31 Tom Lane <tgl@sss.pgh.pa.us> parent: Swathi S <ss.postgres@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2008-11-20 16:31 UTC (permalink / raw) To: Swathi S <ss.postgres@gmail.com>; +Cc: pgsql-admin "Swathi S" <ss.postgres@gmail.com> writes: > How do we find which user logged in from the OS level in postgres. > For eg: If user "a" logged in from the OS level and logged into postgres > psql as user "b" .........how do we find the login details? You don't --- there's no way to find that out from the server side. What you might consider doing is tying the OS and postgres user identities together by using "ident" authorization --- but that's not real secure unless all the connections are local. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-11-20 16:31 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-11-20 12:12 User login Swathi S <ss.postgres@gmail.com> 2008-11-20 16:31 ` Tom Lane <tgl@sss.pgh.pa.us>
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