Postgres Pro
Downloads
Home   >   mailing lists

Re: blocking the alter role command - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: blocking the alter role command
Date
Msg-id CAFcNs+oSRxN=qyjs81JPXVBCoPJmS5wVPiLjrK-uenuXTbFMMQ@mail.gmail.com
Whole thread Raw
In response to blocking the alter role command  (JotaComm <jota.comm@gmail.com>)
List pgsql-hackers
Tree view


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 by date:

Previous
From: JotaComm
Date:
Subject: blocking the alter role command
Next
From: Jim Nasby
Date:
Subject: Weird behavior during CREATE EXTENSION