Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mike Aubury — — source: Informix-list mailing list archive (1991-1998)
One way - is to make sure permissions are set at user level
for the second database on all the tables.
Create a new table which you'll allow users of the first
database to insert into.
Finally - run a program at regular intervals to update the
relevant tables in the second database using the data in the
new table.
As you specified 5.0x I dont know if you have access to
triggers, but I'll assume you do...
You could create a DBA procedure to do the update for you upon
an insert into the new table (so you dont need to run the
program mentioned above at all).
Alternativly - give the users connect permission and let
them execute the DBA procedure directly.
--
--
Mike Aubury _\\?/_
|O O|
+----------oOOO-\\_/-OOOo-------+------------------------------
-+
| Heisenberg may have been here| mike@aubury.demon.co.uk
|
| | http://www.aubury.demon.co.uk
|
+------------------------------+------------------------------
-+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.