I host out of an Oracle Web application to the Unix command line. By default I am a user named 'ora9i'. I would like to call a script that logs me in as another user...I will know the username and password, run their .profile to access a couple of common environment variables, and then execute a command using the values of these variables. Is this possible within a single script? Is it possible at all?

I would like to:

• su - my username/my password (i assume the su will run the .profile)
• execute an OS command and pass certain environment variable as parameters of the command

Any suggestions would be very helpful. Thanks.

You could use a single command for that.
The 'su -' will take care of the .profile and set the env variables. You just have to know what they are and pass them in to the command.

Thanks, but what about the password? Won't this interactively prompt for a password? Is there a way to also pass in the password so that the command can be used in a script?

Thanks in advance.