switch user in script using sur (restricted)
Posted on 2000-02-25
I'm trying to write a script that runs as oracle and needs to do a 'sur -' (switch user root) to kill off other user id's. These hung id's are not connect to oracle and this is not a oracle problem, they remain hung even after oracle is shut down. The application leaves connections hung. (No luck getting appls to fix this one! :) )
I know how to 'su - ' to another user and execute a command/script if you are running the script as root but how can do a 'sur -' in a script run by Oracle and execute a command/script.
The Oracle id does have 'sur - ' privileges and while we could always create at separate script it would be much easier if this could be done in one script.