Re: psql missing feature: show permissions for functions

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: psql missing feature: show permissions for functions
Дата
Msg-id 132201c49f5f$5444efd0$0200a8c0@hogranch.com
обсуждение исходный текст
Ответ на psql missing feature: show permissions for functions  (Jorge Godoy <godoy@ieee.org>)
Ответы Re: psql missing feature: show permissions for functions  (Jorge Godoy <godoy@ieee.org>)
Список pgsql-bugs
> I was trying to check some permissions on functions and then I noticed
> that there's no command in psql to show that information.  I've tried
> using "\z", "\df" and "\df+" without success on PostgreSQL 7.4.5.
>
> It would be an interesting addition to have that, as we do have the
> commands to show permissions on tables.

ah, I found it.  try...

    SELECT proacl FROM pg_proc WHERE proname='functioname';

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

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Error starting service on Win2k
Следующее
От: Jorge Godoy
Дата:
Сообщение: Re: psql missing feature: show permissions for functions