Re: Handling users

From: "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Handling users
Date: 2003-02-18 14:11:38
Message-ID: 200302181941.38502.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 18 Feb 2003 7:47 pm, you wrote:
> On Tue, Feb 18, 2003 at 19:13:51 +0530,
>
> "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>"
<shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:
> > 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?)
>
> If you are using domain sockets and the OS supports it, why wouldn't you
> want to use ident authentication?

Correct me if I am wrong, but when I run ident authentication, I have to
create OS users right? And with sshd enabled on box for admin reasons, I
don't want to let everybody login. I agree I can set their login to
/sbin/false on linux or nologin on BSD.

but under full load I expect around 50 concurrent users. With 15-20
connections shuffling thr. users with set authorisation for each web request,
I don't want to trust /etc/passwd for performance at hundreds of users.

> The other option is to use password authentication and make sure you keep
> the binaries secret so people can't find out what the passwords are. In
> most cases I would expect password authentication to be higher risk than
> ident authentication when you only allow connections through domain
> sockets.

Which binaries? My application? I am silghtly confused here..

I want to use password authentication. But my problem is set session
authorisation does not support a password clause.

I have not installed a test database as yet. This is out of documentation. May
be experimenting with things might turn out few things..

Again, any help using password authentication?

Shridhar

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-02-18 14:17:14 Re: Handling users
Previous Message Bruno Wolff III 2003-02-18 13:52:57 Re: Handling users