Re: How to allow users to log on only from my application not from pgadmin

[Mark Walker <furface@xxxxxxxxxxxx>]

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.