Re: shell script and validating userid/password

Hi Jenny,

Give your sys admin a set of scripts that work and then all they have to do is type in the name of the script and any runtime parameters. If the scripts you provide are Unix "here" documents they can have the login id and passwords embedded to that they don't appear when someone issues a "ps -ef" (or similar depending on the Unix variant you are using)

regards
Jerry Gitomer

Jenny Farnham wrote in message
<7n4jdc$jg7_at_peabody.colorado.edu>...
>
>Howdy Gurus,
>
>We have a bourne shell script that we will be
>having a System Admin type in the username/password
>and connect string.
>
>Example: run_shell_script jingle/claus_at_northpole_xya
>
>In this shell script we are executing a sql*plus script.
>
>Here's the scenario/proplem.
>
>If the System Admin types in a wrong userid/password/dblink
>connect string, then when the sqlplus tries to use it,
>it just hangs and the shell script hangs.
>
>What is the best way to validate the connect string?
>or
>Is there a way to get sql*plus to auto exit out if the
>connect string is invalid?
>
>We are NOT going to use the option of the "/" for many reasons.
>(Example: sqlplus /).
>
>Thanks for any insight -----------------------------------------
Received on Wed Jul 21 1999 - 11:28:22 CDT