On Tuesday 18 Feb 2003 7:22 pm, you wrote:
> On Tue, Feb 18, 2003 at 18:30:59 +0530,
>
> "Shridhar Daithankar<shridhar_daithankar@persistent.co.in>"
<shridhar_daithankar@persistent.co.in> wrote:
> > In this scheme, how can I authenticate user without fiddling with
> > postgresql system catalogs? I mean I have and established connection as
> > database superuser, a username and a password. Now I want to
> > authenticate. How do I do it?
>
> You can use ident authentication and allow the user the application runs
> under to connect as any of the users that it is supposed to be able to.
> If the application software is running on the same box as the database
> server and the OS supports it, you can use local (domain socket)
> connections and use ident without running an ident server.
I don't want to do that unless that is last option. And yes, the application
and database are on same machine and it will be unix domain socket only for
security reasons. ( I mean just trying to be paranoid. The application is on
company intranet but why take chance?)
Shridhar
