Hi Jon I'm logging on with oracle user which is UID 501. It seems to start the cron job with the root user, but I don't know why. For example I make this little test:
8 51 * * * /bin/ls -als I receive a message with the result. The listing was the root folder of my oracle user (/home/oracle), but the e-mail was still sent by user root. I did the same test on my Solaris, the result was the same except the mail was sent by user oracle. Any other hints? Regards -Yanick ----------- Yanick Quirion Administrateur Réseau/Network Manager NEOKIMIA INC. Institut de Pharmacologie de Sherbrooke 3e étage (Édifice Z5) 3001 12e avenue Nord Sherbrooke, Québec CANADA J1H 5N4 Tél.: +1 819 820-6040 Direct: +1 819 820-6855 Fax.: +1 819 820-6841 email: [EMAIL PROTECTED] -----Original Message----- From: Jon Haugsand [mailto:[EMAIL PROTECTED] Sent: 30 May, 2003 08:37 To: [EMAIL PROTECTED] Subject: Re: Using Cron Table * Yanick Quirion > I have a little problem when using linux redhat crontab. I want to > run an Oracle SQL script using the oracle user. On the user, I use > command crontab -e and add the line, for example: > > 0 12 * * * /home/oracle/SQL_Script/script1.ksh > > The script will run, but it will be start by user "root". When the > job is completed, I will have a message from root. This causes me > problem, because the user root is not able to connect to the oracle > database without specified the "sys" password into the script. My test show that the script is run under the logged in user. Are you sure that you are not user root when you issue the 'crontab -e' command? It is not the case that it is the current working directory that decides what crontab file you're using. Try an 'id' command. -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://www.redhat.com/mailman/listinfo/redhat-list