RE: Update remote table from within a procedure

Posted in 2005

Doug Conrey — Thu, 17 Nov 2005 11:14:54 -0700 — source: Usenet: comp.databases.informix

Yes, I can run the update manually. I ran it as my username, which has dba permissions on all the databases involved. The strangest part is that if I run the update manually, then immediately run the stored procedure, it works. If I don't run the update manually it doesn't work. DC > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org] On Behalf Of david@smooth1.co.uk > Sent: Thursday, November 17, 2005 9:26 AM > To: informix-list@iiug.org > Subject: Re: Update remote table from within a procedure > > > Can you run the update manually? > > This sounds like the permissions are different across the databases. > > What permissions do the user have? > > Resource/dba on the database? > update on the table? sending to informix-list