Skip site navigation (1) Skip section navigation (2)

Re: User login

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Swathi S" <ss(dot)postgres(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: User login
Date: 2008-11-20 16:31:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
"Swathi S" <ss(dot)postgres(at)gmail(dot)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" 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

In response to

pgsql-admin by date

Next:From: Robert TreatDate: 2008-11-20 19:37:06
Subject: Re: Is it safe to reset relfrozenxid without using vacuum?
Previous:From: Swathi SDate: 2008-11-20 12:12:53
Subject: User login

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group