Re: Restrict permissions on schema to hide pl/pgsql code

Поиск
Список
Период
Сортировка
От Swanand Kshirsagar
Тема Re: Restrict permissions on schema to hide pl/pgsql code
Дата
Msg-id CAMn6ZASyECgGPn1TtPnimgBXjFY--=Ay7SYFouvVG4PV3NSrJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Restrict permissions on schema to hide pl/pgsql code  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Restrict permissions on schema to hide pl/pgsql code
Список pgsql-admin
Дерево обсуждения
Yes, that's the reason why I tried revoking permissions from pg_catalog.pg_proc table.

What's the right way to notify this OR check if there is any plan in roadmap?

On Wed, Jul 24, 2019 at 6:58 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wednesday, July 24, 2019, Swanand Kshirsagar <swanandon@gmail.com> wrote:
Isn't revoking permissions from a schema should take care of this situation?

The pl/pgsql function body is stored in pg_catalog which the user still has permission to read.  There isn’t a good/supported way to work around this behavior.

David J.


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_locks relation cant be found in pg_class
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Restrict permissions on schema to hide pl/pgsql code