Re: Running Utilities as anothe
Posted in 1997
John,
I had a similar problem with letting others run ontape - I didn't want to
give out the informix password. I wrote a program which does an "su
informix" and then executes whichever informix utility, passing on the
command-line parms. The user does not have to know the informix
password. In fact, they don't even have to know that they are becoming
"informix". The su only affects the process executing the command, thus
the user does not get the chance to do anything dangerous with the
more-powerful id. Check it out in the software archives of IIUG
(http://www.iiug.org). It is stored there as "suontape". I have
modified it at various times to run oncheck and onmode, so I know it
works for them.
Mark Collins
mcollins@us.dhl.com
==============================================
We are trying to implement Maestro, which is a scheduling package which
is supposed to run all of our batch, scripts, etc.. We currently have it
running our backups through onarchive, but our next step is to be able to
run onchecks and update statistics through the tool. I believe to be
able to run these commands, the user has to be INFORMIX, but if some one
has a way around this, so that another user can run them, I would
appreciate their input.
One way which I don't want to implement is to " su - informix" then
provide the password, this would mean having the password hardcoded, and
against our policy.
Thanks in advance
JP