blocking the alter role command

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]https://github.com/michaelpq/pg_plugins/tree/master/hook_utility

Regards,

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

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL