Re: has_database_privilege is true?

Поиск
Список
Период
Сортировка
От Paul Förster
Тема Re: has_database_privilege is true?
Дата
Msg-id 40B78792-EE61-44A7-B67F-853D0AF4D315@gmail.com
обсуждение исходный текст
Ответ на Re: has_database_privilege is true?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Hi Stephen,

> On 23. Aug, 2020, at 16:52, Stephen Frost <sfrost@snowman.net> wrote:
> 
> If you want has_database_privilege() to return that the user doesn't
> have access due to missing GRANT privileges, yes.
> 
> An alternative would be to query against pg_roles and check the
> 'rolcanlogin' privilege/column.  Again, a user has to have both in order
> to be able to actually log in.

which I did (see previous post). Thanks very much for clearing that up.

Cheers,
Paul



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: has_database_privilege is true?
Следующее
От: harish supare
Дата:
Сообщение: Substitute Variable in select query