Hi Mark,

Its not necessarily a good idea to have an entire database become
read-only. What if you have reports or procedures that need to populate
tables in order to execute?

It's a better idea to apply read-only options to specific tables. There
are a few options:

1. Modify each table to readonly.
or,
2. Drop all the insert, update, delete grants.

Martin Bowes

-----Original Message-----
From: info-ingres-bounces@kettleriverconsulting.com
[mailto:info-ingres-bounces@kettleriverconsulting.com] On Behalf Of Mark
Sent: 03 April 2008 14:25
To: info-ingres@kettleriverconsulting.com
Subject: [Info-Ingres] Disable database updates temporarily?

Hi,

Is there any way to configure Ingres so that changes to the database
can be disabled? I have a lot of legacy (ESQL) code that needs to
operate in a passive mode sometimes. Therefore it must read but not
write to the database. I'd rather not have to change all the code if
possible.

TIA, M.
_______________________________________________
Info-Ingres mailing list
Info-Ingres@kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres