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"
