Re: Protect extension' internal tables - how? - Mailing list pgsql-hackers

From Nikita Malakhov
Subject Re: Protect extension' internal tables - how?
Date
Msg-id CAN-LCVNqKqfR8wx9czDM_8SB4j9-OdqQEWz=-N6uR=EBDovkfg@mail.gmail.com
Whole thread Raw
In response to Re: Protect extension' internal tables - how?  (Aleksander Alekseev <aleksander@timescale.com>)
List 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

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: In Postgres 16 BETA, should the ParseNamespaceItem have the same index as it's RangeTableEntry?
Next
From: Sofia Kopikova
Date:
Subject: Re: Add TOAST support for more system tables