Re: Prevent from Deletion - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Prevent from Deletion
Date
Msg-id 3F54BA28.7020302@fireserve.net
Whole thread Raw
In response to Re: Prevent from Deletion  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
DBA's never would make the mistake of deleting a record that is a key
part of a design, of course.

 ;-)



Ron Johnson wrote:

>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?
>
>
>


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Prevent from Deletion
Next
From: Gianni Mariani
Date:
Subject: Re: About GPL and proprietary software