Re: RFC: Command Restrictions by INI file with Audit Logging (DROP/TRUNCATE/DELETE)

From: ADRIANO BOLLER <adriano(at)wxsolucoes(dot)com(dot)br>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RFC: Command Restrictions by INI file with Audit Logging (DROP/TRUNCATE/DELETE)
Date: 2025-05-05 16:13:45
Message-ID: 196a1398ae1.11a7442b7121908.5297274322243829962@wxsolucoes.com.br
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Guys

Please read suggestions:

https://grok.com/share/bGVnYWN5_365c76f0-3086-4231-9e5d-8dd99c9f3d2b

Suggestion with json

Please 

Best Regards

 

ADRIANO BOLLER

CEO WX SOLUÇÕES LTDA 
CNPJ: 14.421.060/0001-92
Desenvolvimento de Sistemas e Consultoria WX
Representante Windev, Webdev, Windev Mobile
HOSPEDAGEM WEBDEV É COM O SERVERWX

Tel. :   https://api.whatsapp.com/send/?phone=41999491800&text=Ol%C3%A1%21+Seja+bem+vindo%28a%29+%C3%A0+WXSolu%C3%A7%C3%B5es%2C+como+posso+ajud%C3%A1-lo%28a%29+hoje%3F&type=phone_number&app_absent=0https://api.whatsapp.com/send/?phone=41999491800&text=Ol%C3%A1%21+Seja+bem+vindo%28a%29+%C3%A0+WXSolu%C3%A7%C3%B5es%2C+como+posso+ajud%C3%A1-lo%28a%29+hoje%3F&type=phone_number&app_absent=0  /  https://api.whatsapp.com/send/?phone=41998519291&text=Ol%C3%A1%21+Seja+bem+vindo%28a%29+%C3%A0+WXSolu%C3%A7%C3%B5es%2C+como+posso+ajud%C3%A1-lo%28a%29+hoje%3F&type=phone_number&app_absent=0

Rua Rene Dinorah da Silveira, 70 - Tarumã - Curitiba - Paraná - Brasil

SKype/Telegram : http://adrianoboller

Mail : mailto:adriano(at)wxsolucoes(dot)com(dot)br ou mailto:adrianoboller(at)gmail(dot)com 

Site :  http://wxsolucoes.com.br



---- On seg, 05 mai 2025 12:01:10 -0400 tgl(at)sss(dot)pgh(dot)pa(dot)us<tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote ----

"David G. Johnston" <mailto:david(dot)g(dot)johnston(at)gmail(dot)com> writes:

> On Sunday, May 4, 2025, ADRIANO BOLLER <mailto:adriano(at)wxsolucoes(dot)com(dot)br> wrote:

>> Subject: RFC: INI-based Command Restriction Layer for DROP/TRUNCATE/DELETE

>> with Audit Logging

> I seem to recall similar features being discussed previously. Finding

> those discussion would be nice.

I don't have an opinion on whether this is actually a feature we want,

but a couple of thoughts:

1. This seems to overlap a whole lot with one intended use-case for

event triggers. You could likely build it as an extension, relying

on an event trigger to get control at the right places.

2. The choice of .INI format for the config file seems a bit

non-simpatico for Postgres. We have nothing else that uses that,

which for starters means you'd have to write your own parser.

Something that might integrate better is JSON; we already have

code for that, and use-cases such as backup manifest files.

            regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Yura Sokolov 2025-05-05 16:21:29 Re: Fix a race condition in ConditionVariableTimedSleep()
Previous Message Tom Lane 2025-05-05 16:01:10 Re: RFC: Command Restrictions by INI file with Audit Logging (DROP/TRUNCATE/DELETE)