At 12:21 PM 14/02/2006, you wrote:

>On Feb 13, 2006, at 15:39, Alexandre Benson Smith wrote:
>
> > take a look on gfix
> >
> > gfix -mode read_only foo.
>
>Interesting! Is this available through the FB API?

Through the Services API, yes. But changing the database mode is a
trick that can only be done by SYSDBA or Owner and only in exclusive
mode. The simplest way to do it by calling gfix -mode read_only
command from the command line. It will fail if anything else is connected.

Of course, you must *make* the mode change while the database is on
writable media!! Just make sure, when you go to do this, that
everything about the database is set in concrete. There literally
only one thing you can do to change a read_only database and that's
to run gfix -mode again with the read_write argument. :-)

./hb