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

Поиск
Список
Период
Сортировка
От Chris Curvey
Тема Re: Disallow access from psql, or allow access only from specific client app
Дата
Msg-id CADfwSsCsSF49TAXi8D=s-hOWoKkoy9BuFw+NCVR4HCfyxrmfiA@mail.gmail.com
обсуждение исходный текст
Ответ на Disallow access from psql, or allow access only from specific client app  (Mario Puntin <mariomop@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Disallow access from psql, or allow access only from specific client app
Следующее
От: Kurt Buff
Дата:
Сообщение: Re: Disallow access from psql, or allow access only from specific client app