Re: Long term read-only records? - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Long term read-only records?
Date
Msg-id 3E81DAAD.5040103@cvc.net
Whole thread Raw
In response to Long term read-only records?  (Jason Hihn <jhihn@paytimepayroll.com>)
Responses Re: Long term read-only records?  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
You can also set users to not do things like triggers, views, functions, etc,
and basically leave nothing but SELECT. That won't work?

Jason Hihn wrote:
> Is there a way to make a record read-only for months or years? My intent is
> that after a cutoff (a program can run making rows r/o) existing records can
> no longer be modified without unlocking first. User security is
> insufficient, since that only applies to tables. I'd rather not have to
> maintain a R/O flag (or date) in code, because it relies on correct,
> voluntary implementation every time. I'd like something more enforceable
> then that, and that has me looking to the DBMS
>
> Thank you for your time.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: Jason Hihn
Date:
Subject: Long term read-only records?
Next
From: Dennis Gearon
Date:
Subject: Re: Long term read-only records?