Re: Disallow access from psql, or allow access only from specific client app - Mailing list pgsql-general

From Chris Curvey
Subject Re: Disallow access from psql, or allow access only from specific client app
Date
Msg-id CADfwSsCsSF49TAXi8D=s-hOWoKkoy9BuFw+NCVR4HCfyxrmfiA@mail.gmail.com
Whole thread Raw
In response to Disallow access from psql, or allow access only from specific client app  (Mario Puntin <mariomop@gmail.com>)
List pgsql-general
On Sun, Jul 24, 2011 at 5:36 PM, Mario Puntin <mariomop@gmail.com> wrote:

Hi everybody:
I searched the web trying to find an answer to this, but found none. I have a postgresql server and a database, and I granted access to some users.
However I want them to access the data only through some specific client application. I do not want them to have access through psql or some other kind of client app. But, as I created them a user/pass they could use them.
What would you do?
Thanks in advance.

I would modify  their given username and/or password within the client application.  So you tell someone that their username is "chris" and their password is "monkey", but in your app you add "face" to the username and "butt" to the password, so their postgres username is "chrisface" and their postgres password is "monkeybutt".

-Chris(face)



--
e-Mail is the equivalent of a postcard written in pencil.  This message may not have been sent by me, or intended for you.  It may have been read or even modified while in transit.  e-Mail disclaimers have the same force in law as a note passed in study hall.  If your corporate attorney says that you need an disclaimer in your signature, you need a new corporate attorney.

pgsql-general by date:

Previous
From: Chris Travers
Date:
Subject: Re: Disallow access from psql, or allow access only from specific client app
Next
From: Kurt Buff
Date:
Subject: Re: Disallow access from psql, or allow access only from specific client app