| 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
| 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) |