RE: Run 4GL Program without Database Permissions?

Hmmm.. Why don't you set up an application that, whenever users of group (1) need to add records to DB (2), creates a text file with the appropriate info in a ad hoc dir, and a cron job (with the appropriate rights) that periodically collects and processes such files? ciao, marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On 3 Sep 1996 14:02:05 GMT Richard Spitz <spitz@GANS2X.ana.med.uni-muenchen.de> wrote: Dear Informixers, please help me with the following problem: In our department, we have, among others, two groups of applications with their own databases behind them: 1) Management of the operating room schedules 2) Management of the pain therapy department So far, both have been used by completely distinct groups of users who have nothing to do with each other, especially not with each other's databases. There are about 25 users defined for database (1) and about 15 for (2). Now I need to write a program so that a user of the OR scheduling program can automatically notify the pain dept. of a patient undergoing postoperative pain therapy. This means that a user out of group (1) must be able to invoke a 4GL program with write access to database (2). What I must avoid is having to grant these users any privileges for data- base (2). This is rather awkward to handle in Online 5.0x and a lot of work to keep up to date, since there are no "roles". When I experimented with the "s"-Bit, I got the error message: dynamic linker: postop.4ge: can't find lib4gl.1 Killed However, LD_LIBRARY_PATH is set correctly, and other 4GL programs without the "s"-Bit set can be run without problems. What's wrong? Any suggestions about how my problem could be solved? Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3413 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+ -----------------End of Original Message-----------------