Re: How to allow users to log on only from my application not from pgadmin - Mailing list pgsql-general

From Mark Walker
Subject Re: How to allow users to log on only from my application not from pgadmin
Date
Msg-id 45C14C13.50602@omnicode.com
Whole thread Raw
In response to Re: How to allow users to log on only from my application not from pgadmin  (Paul Lambert <paul.lambert@autoledgers.com.au>)
Responses Re: How to allow users to log on only from my application not from pgadmin  (Mark Walker <furface@omnicode.com>)
List pgsql-general
But you don't have to turn it on by default for any particular database,
and you could sign any application you want for your individual server.


Paul Lambert wrote:
> Mark Walker wrote:
>> One other thing.  Another approach to this problem would be to have
>> some sort of code signing/authentication capabilities for the
>> postgresql server.  For instance, you login as an administrator (some
>> sort of enhanced privs), you get to look at the databases you have
>> permission for.  Otherwise, postgresql has to recognize the
>> application.  Has this ever been discussed?
>>
>>
>>
>
> I don't think it would be feasible for any RDBMS to recognise the
> connecting application, certainly in my view the effort it would take
> to alter the postmaster/odbc driver and others would be a lot more
> than the apparent gain from having that functionality.
>


pgsql-general by date:

Previous
From: Paul Lambert
Date:
Subject: Re: How to allow users to log on only from my application not from pgadmin
Next
From: Ron Johnson
Date:
Subject: Re: How to allow users to log on only from my application not from pgadmin