Thanks Adam. The list of users changes often. So constraining uses
is not attractive. The datafile cannot be made read-only. Adding
before-update and before-delete trigggers with exceptions in the
triggers will allow insertions.

RB

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...>
wrote:

> --- In firebird-support@yahoogroups.com, "russellbelding"
> <russell@b...> wrote:
> > I have some look-up tables I'd like to make read-only. One way

to do

> > this is to put before-update, before-insert, before-delete

triggers

> > on
> > these tables and in the triggers place exceptions. Any

suggestions of

> > other ways to make a table a read-only-table?
> > Thanks
> > Russell Belding
>
> Deny insert and update and delete permissions to the applicable

users

> or roles. (which may be everyone other than SYSDBA). Obviously

someone

> needs write permissions at some stage or the table will be empty.
>
> There is also an option to make the entire database read only. But

the

> trigger option will also work.
>
> Adam