On Tue, Mar 22, 2011 at 12:28 PM, Guillaume Lelarge
<guillaume@lelarge.info> wrote:
Le 22/03/2011 13:14, Roger Demetrescu a écrit :
> [...]
> When registering a new server in pgAdmin, the field Username is
> required. The problem is I have several databases in my servers, each
> one with its own owner.
> So, if I need to connect to customer1_db, I have to change the
> properties of Username at the server configuration to 'customer1'.
> When I need to connect to customer2_db, I have to change username to
> 'customer2', and so on...
>
> Is there any way to force pgAdmin to ask for username AND password
> just before I connect to the server? IMHO it is more practical than
> the current approach I am forced to follow.
>
> Maybe I am missing something here, so any advice would be very appreciated.
>
You can't right now. But I agree that this is something I would like to
have too (mostly for testing purpose). And it feels more pratical this way.
If the username is specific to the database, then it doesn't make sense to ask for it when connecting to the server. What is required (I think) is the ability to specify a role for each database. It would be stored as a per-user setting alongside the schema restriction.
--
Dave Page
Blog:
http://pgsnake.blogspot.comTwitter: @pgsnake
EnterpriseDB UK:
http://www.enterprisedb.com The Enterprise PostgreSQL Company