Re: Prevent from Deletion

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Prevent from Deletion
Дата
Msg-id 1062515828.7340.153.camel@haggis
обсуждение исходный текст
Ответ на Prevent from Deletion  (Alex <alex@meerkatsoft.com>)
Ответы Re: Prevent from Deletion  (Dennis Gearon <gearond@fireserve.net>)
Список pgsql-general
On Sun, 2003-08-31 at 22:07, Alex wrote:
> Hi,
> I have tables that have default records that must not be deleted or
> modified.
> Is there an easy way to do this. Like setting a trigger on the Primary
> key value ?

How about revoking DELETE and UPDATE privileges from all users
except the DBA?

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Those who would give up essential Liberty to purchase a little
temporary safety, deserve neither Liberty nor safety." or
something like that
Ben Franklin, maybe


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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: About GPL and proprietary software
Следующее
От: Dennis Gearon
Дата:
Сообщение: Re: Prevent from Deletion