James,

There are a couple of ways to handle this. While you can't necessarily set
the database to read only, you can prevent users from updating it.

One solution is to write a program that opens the database, calls DBLOCK
against the database, then go into an infinite loop calling the PAUSE
intrinsic to go to sleep forever, or until you abort the program/job,
whichever comes first.

Another method is to write a program to intercept the call to DBOPEN and
change the mode to 5. The downside to this is that each program on the
system must be run specifying the XL for the interception to occur.

I just finished installing a version of Query using this solution giving
certain users read only access to databases. It also intercepts the
HPCICOMMAND intrisic and NO-OPs it disallowing CI access as well.

Doug.

Doug Werth                             Beechglen Development Inc.
[log in to unmask]                               Cincinnati, Ohio

The opinions expressed do not  necessarily represent the views or
opinions of Beechglen Development. They might but not necessarily.
They represent solely the opinions of the author.


----- Original Message -----
From: Reynold, James <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, December 30, 1999 2:50 PM
Subject: Read only access to Image DB


> Greetings Folks.
>
> Is there an easy way using dbuitl to set an database to read only ??
>
> Thanks
>
> James Reynolds
> HP3000 System Administrator
> Presbyterian Health Plan
> Albuquerque, NM
> [log in to unmask]
> 505-923-8076