From: | Roger Demetrescu <roger(dot)demetrescu(at)gmail(dot)com> |
---|---|
To: | Dave Page <dpage(at)pgadmin(dot)org> |
Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: How do I configure pgAdmin to ask for username when connecting to a server? |
Date: | 2011-03-22 13:21:40 |
Message-ID: | AANLkTikpuVPjhXRYy3HT1SkgKwO5z8-+h-0cHBF7HRBq@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Tue, Mar 22, 2011 at 09:35, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>
>
> On Tue, Mar 22, 2011 at 12:28 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)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.
But wouldn't that require me to connect to the server as 'postgres' ?
Otherwise how would you allow one to play as 'user2' in database2 if
he connected as 'user1' in the server ?
Anyway, I never heard about one been able to play multiples roles
using the same connection.
Cheers,
Roger
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2011-03-22 13:37:17 | Re: How do I configure pgAdmin to ask for username when connecting to a server? |
Previous Message | Dave Page | 2011-03-22 12:35:28 | Re: How do I configure pgAdmin to ask for username when connecting to a server? |