Обсуждение: blocking the alter role command

Поиск
Список
Период
Сортировка

blocking the alter role command

От
JotaComm
Дата:
<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Hello,<br /><br
/></div><divclass="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">I would like to know if is
itpossible to block the following command: ALTER USER myuser PASSWORD;<br /><br /></div><div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:x-small">​Mytarget is allow ​to execute this command from a specific
address.<br/><br /></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:x-small">Thanks a
lot.<br/></div><br /><div class="gmail_default"
style="font-family:verdana,sans-serif;font-size:x-small">​Regards​</div><br/>-- <br /><div
class="gmail_signature">JotaComm<br/><a href="http://jotacomm.wordpress.com"
target="_blank">http://jotacomm.wordpress.com</a></div></div>

Re: blocking the alter role command

От
Fabrízio de Royes Mello
Дата:


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