Re: Disallow access from psql, or allow access only from specific client app

On Sun, Jul 24, 2011 at 5:36 PM, Mario Puntin <mariomop(at)gmail(dot)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.