Postgres Pro
Downloads
Home   >   mailing lists

Re: Proper use of Groups and Users (Roles). - Mailing list pgsql-general

From Vincent Veyron
Subject Re: Proper use of Groups and Users (Roles).
Date
Msg-id 20160216175943.c2994b6c59ac8ed5ceb51886@wanadoo.fr
Whole thread Raw
In response to Re: Proper use of Groups and Users (Roles).  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: [SQL] refer function name by a variable in the function body
Next
From: Tom Lane
Date:
Subject: Re: Suggest note in index documentation about long running transactions