What version of ESQL/C and of SE???Quote:>System: SCO Unix 3.2.2, Informix database
Are you *sure*? Not being familiar with how SCO's at(1) handles theQuote:>We are trying to schedule an Informix (ESQL/C)-using process for
>execution with the at command. The problem is:
> - when the job is executed by cron via at, access to the
> database is not allowed if run under any id other than root
>These same ids are able to execute the very same program successfully
>from the command line.
>We have checked the enviromental variables (which are correct) and
>the user/group id assigned the job by at (which are also correct).
uid issues, I don't even know the right questions to ask. You don't have
any of the C2 stuff enabled, do you?
Try dumping your env variables (INFORMIXDIR, PATH [if used], DBPATH, SQLEXEC,
etc.]) from within your program to make sure at isn't doing something you
We reset ruid and euid; also, the engine process runs as gid "informix".Quote:>I dont know if Informix is checking something other than the u/gid
>to determine the user or what, but we absolutely cannot access the
>db under a non-root id, even after granting dba privledges to all.
I haven't heard of any problems when C2 is properly relaxed.Quote:>Informix tech support has not been of any help so far.
>Has anyone else seen anything like this???
Smith and Wesson: the Ultimate Point-and-Click User Interface.