Is there a distributed database with rights check during replication?

Question

Database

It is required to raise a distributed database on a small number of nodes (approximately from 10 to 100) with equal rights, but somehow limit the destructive abilities of participants who do not particularly trust each other. For example, forbid everyone to delete other people's (or any) documents.
As far as I understand, existing distributed solutions assume that all nodes have the same full access to the database (unless it's master-slave replication, which is not appropriate). And if one of the participants erases half of its base, then its changes will safely disperse throughout the network.
Is there something ready? Or is it worth trying to integrate into the open-source database, add the necessary layer with permission check?
I would like to find a SQL solution, but it is interesting to see NoSQL as well, if there are any.
The amount of data is not expected to be very large. Distribution is needed for reliability, free work with data on your side and for the lack of strong centralized control.

Answer 1

The problem is initially unsolvable. The very ideology of replication does not allow what is described in the question. What is actually causing this problem? She didn't just come out of thin air, right?

Answer 2

On the contrary (in CREATE SECURITY POLICY there is NOT FOR REPLICATION), you can create row-level security for the replica.