auth methods

From: David Bear <David(dot)Bear(at)asu(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: auth methods
Date: 2006-02-08 20:12:14
Message-ID: 20060208201214.GC21865@asu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

after reading through
http://www.postgresql.org/docs/8.0/static/auth-methods.html

I'm still left wondering how to solve something that should be simple.

Ident method looks like it might work.

All I really want to do is prevent user jack, who is logged in and
properly authenticated to the system as jack, from connecting to pg as
user joe. I have kerb authentication working for all ssh connections
to the data base server. I don't want another layer of authentication
for postgresql.

I'm currently using the trust method, but any user can connect to pg
as any other pg user.

the trouble is that ident seems to be non existent in suse linux (at
least, it doesn't seem to be installed )

any pointers would be appreciated.

--
David Bear
phone: 480-965-8257
fax: 480-965-9189
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
"Beware the IP portfolio, everyone will be suspect of trespassing"

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2006-02-08 21:47:48 Re: auth methods
Previous Message CG 2006-02-08 19:59:33 Cross schema Primary Key Indexes problem with datatype in the public schema