Re: blocking the alter role command

Поиск
Список
Период
Сортировка
От Fabrízio de Royes Mello
Тема Re: blocking the alter role command
Дата
Msg-id CAFcNs+oSRxN=qyjs81JPXVBCoPJmS5wVPiLjrK-uenuXTbFMMQ@mail.gmail.com
обсуждение исходный текст
Ответ на blocking the alter role command  (JotaComm <jota.comm@gmail.com>)
Список pgsql-hackers


On Tue, Jan 12, 2016 at 8:32 PM, JotaComm <jota.comm@gmail.com> wrote:
>
> Hello,
>
> I would like to know if is it possible to block the following command: ALTER USER myuser PASSWORD;
>
> My target is allow to execute this command from a specific address.
>
> Thanks a lot.
>

You should implement an extension using ProcessUtility_hook todo that. See an example in [1]

Regards,

[1] https://github.com/michaelpq/pg_plugins/tree/master/hook_utility

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello

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

Предыдущее
От: JotaComm
Дата:
Сообщение: blocking the alter role command
Следующее
От: Jim Nasby
Дата:
Сообщение: Weird behavior during CREATE EXTENSION