Re: Protect extension' internal tables - how?

From: Nikita Malakhov <hukutoc(at)gmail(dot)com>
To: Aleksander Alekseev <aleksander(at)timescale(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Protect extension' internal tables - how?
Date: 2023-07-18 11:19:44
Message-ID: CAN-LCVNqKqfR8wx9czDM_8SB4j9-OdqQEWz=-N6uR=EBDovkfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Aleksander, thank you very much.
Tables are already placed into special schema, but there are some
dynamically
created tables and the goal is to protect all these tables from direct
insert, update
and delete operations from users. I've read about the SECURITY DEFINER,
it will do the trick.

--
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company
https://postgrespro.ru/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Sofia Kopikova 2023-07-18 11:19:46 Re: Add TOAST support for more system tables
Previous Message Amit Langote 2023-07-18 09:58:20 Re: In Postgres 16 BETA, should the ParseNamespaceItem have the same index as it's RangeTableEntry?