Read-Only Database

[BobbyB]

Hi,

We have a Progress V9 database (on a unix server) which we want to allow users to query only.
We are using the client/server model of accessing the data.
Is there any startup parameter on the client or server side for only allowing read-only access ?

Any help greatly appreciated.
Thanks

 

[TomBascom]

Version 9 is ancient, obsolete and unsupported. You should upgrade. OpenEdge 11.3 is the current release.

Your options include the -RO startup parameter. But that isn't a very good option -- it does not follow changes in shared memory which means that your session may (eventually probably will) crash when it gets a record that is "mangled". It also means that you will not be seeing updates in a consistent fashion. It is a useful parameter for situations where those considerations don't really matter -- but such situations are not generally compatible with mission-critical production software

Another option is OpenEdge Replication Plus. This supports "real" read-only connections on a replication target database. But "fathom replication" on verson 9 is much less capable and much harder to work with than OpenEdge Replication on OE10.2+ so I wouldn't really suggest that either (for v9).

 

[BobbyB]

Tom,
Thanks for the quick reply - I'll look into the -RO option.
The system is obsolete but users still want an archived version for read-only so not worth upgrading.

 

[cj_brandt]

Maybe change the _file permissions for each of the user tables to only allow reads.