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

Поиск
Список
Период
Сортировка
От Andrus
Тема How to allow users to log on only from my application not from pgadmin
Дата
Msg-id epj5qj$jm$1@news.hub.org
обсуждение исходный текст
Ответы Re: How to allow users to log on only from my application  (Raymond O'Donnell <rod@iol.ie>)
Re: How to allow users to log on only from my application not from pgadmin  (Bruno Wolff III <bruno@wolff.to>)
Re: How to allow users to log on only from my application not from pgadmin  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-general
Дерево обсуждения 
My application implements field and row level security.
I have custom table of users where user privileges are described.

However user can login directly to database using pgAdmin. This bypasses
the security.

How to allow users to login only from my application ?
I think I must create server-side pgsql procedure for login validation.

How to implement custom authentication in server side ?

How to force PostgreSQL to call stored procedure for user logon validation
when user logins to PostgreSQL ?

Andurs.

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

Предыдущее
От: shalendra.tripathi@gmail.com
Дата:
Сообщение: Re: PQexec does not return.
Следующее
От: "shakahshakah@gmail.com"
Дата:
Сообщение: VACUUM ANALYZE taking a long time, %I/O and %CPU very low