Re: [ADMIN] Acess Control !

Поиск
Список
Период
Сортировка
От Elson Vaz
Тема Re: [ADMIN] Acess Control !
Дата
Msg-id CAJJTqWQWRgCQyVR1Zvs_vvVmEW+RK=6k2+kZBxA=kSCvAXbycQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Acess Control !  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [ADMIN] Acess Control !
Список pgsql-admin
Дерево обсуждения
thank you David J.,

But how i can do this?
for exemple i did this configuration, but is wroge.

# TYPE  DATABASE        USER         ADDRESS           METHOD
host       xpto                   system       10.75.15.60/32       md5
host       xpto                   system       10.72.18.0/24         reject


i want that user system, only conect to xpto database if it come from 10.75.15.60, but if this user "system" come from another adress i want reject this connection, it's possible?





2017-10-03 13:03 GMT-01:00 David G. Johnston <david.g.johnston@gmail.com>:
On Tue, Oct 3, 2017 at 6:46 AM, Elson Vaz <elsonlei@gmail.com> wrote:
gentlemen,

i have one system that conect with one specific user to data base, so i want block acess for this user only if he come from the aplication server.

​
https://www.postgresql.org/docs/9.6/static/client-authentication.html

The pg_hba.conf file is going to be required since you want the access to be conditional on the machine and grant/revoke cannot do that.

David J.
​

В списке pgsql-admin по дате отправления: