DB Authentication Design - Mailing list pgsql-general

From François Beausoleil
Subject DB Authentication Design
Date
Msg-id 5DEE175B-293D-495B-B8BE-260F79E3DCDE@teksol.info
Whole thread Raw
Responses Re: DB Authentication Design
Re: DB Authentication Design
Re: DB Authentication Design
List pgsql-general
Hi all,

I'm thinking that all apps that connect to the database should have their own user. For example, the web application
processis one user, then a report builder process should have another user, and a different process that imports data
shouldhave his own too, and so on. Would you generally agree with that? 

I'm thinking that by having different users, PGbouncer can create different pools, and better allow me to control
concurrency.

Thanks!
François


Attachment

pgsql-general by date:

Previous
From: François Beausoleil
Date:
Subject: Re: pg_stop_backup running for 10h?
Next
From: Szymon Guz
Date:
Subject: Re: DB Authentication Design