Re: Delete rule does not prevent truncate

Поиск
Список
Период
Сортировка
От Rob Sargent
Тема Re: Delete rule does not prevent truncate
Дата
Msg-id 55B181F0.8060401@gmail.com
обсуждение исходный текст
Ответ на Re: Delete rule does not prevent truncate  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: Delete rule does not prevent truncate  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On 07/23/2015 04:15 PM, Karsten Hilbert wrote:
On Thu, Jul 23, 2015 at 12:28:32PM -0600, Rob Sargent wrote:

I'm suggesting OP might find changing truncate statements to deletes
(without a where clause) a simpler solution. Something has to change.
Well, OP isn't looking for a solution to "delete all rows"
but rather to _prevent_ deletion.

Tim can't go forth and tell Blackhats to "please use DELETE
rather than TRUNCATE", right ?

AFAICT it'd be more useful to advise OP to revoke TRUNCATE
rights on tables.

Karsten
Not sure about Tim and the Blackhats (there's a band name in there somewhere) but Wouldn't OP have exact same code to fix, one way or another?

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

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Schema Help Needed To Get Unstuck
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Schema Help Needed To Get Unstuck