Re: Proper use of Groups and Users (Roles).

Поиск
Список
Период
Сортировка
От Vincent Veyron
Тема Re: Proper use of Groups and Users (Roles).
Дата
Msg-id 20160216175943.c2994b6c59ac8ed5ceb51886@wanadoo.fr
обсуждение исходный текст
Ответ на Re: Proper use of Groups and Users (Roles).  (Melvin Davidson <melvin6925@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: [SQL] refer function name by a variable in the function body
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Suggest note in index documentation about long running transactions