When I run a stored process I can issue system commands (since I turned the option on to allow me to do so). These commands run as sassrv - which is the userid that runs our stored processes. I would like to do an SU command to become another user (sas) since I am trying to make a stored process to restart our spawners. However the SU command prompts for a password, and I cant reply to that prompt in my stored process ... or can I?
Just thinking out loud..... but how do you use a Stored Process to restart the Object spawner? The minute you issue the restart command to the spawner, it will kill your stored process, and you will never get any results back to check whether your command was successful. Or are you intending to kill the actual PID's that relate to the Stored Process Server but leave the spawner running?
For what it's worth, if you have SAS connect, you could in theory have an STP that calls a signon to your server but uses the SAS User credentials. Once that connect session is established, you could then execute the call to the object spawner to restart it as you will be now running under the SAS user account.
When I have done this in the past, it has typically been through the use of another 3rd party tool - sudo, upm etc.