Re: Proper use of Groups and Users (Roles).
Vincent Veyron <vv.lists@wanadoo.fr>
From: Vincent Veyron <vv.lists@wanadoo.fr>
To: Melvin Davidson <melvin6925@gmail.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2016-02-16T16:59:43Z
Lists: pgsql-general
On Tue, 16 Feb 2016 09:14:30 -0500 Melvin Davidson <melvin6925@gmail.com> wrote: > The problem is TRUNCATE is more of an administrative privilege. Also, it is > not captured in a DELETE trigger, so you have a security issue with that. Ha, well, learn something new every day > Also, REFERENCES & TRIGGER are schema changes which should never be done by > a normal user. Sure. I was thinking of the data changes. Thanks. -- Bien à vous, Vincent Veyron https://marica.fr/ Gestion des contentieux, des dossiers de sinistres assurance et des contrats pour le service juridique