Re: Running an SQL script from C Shell (Unix)

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Mon, 2 Oct 2000 15:22:56 -0500
Message-ID: <8raqpl$ntt$1@news.gte.com>

If you plan to use sqlplus with the username and password either on the command line or in a shell variable ( both of which can be "seen" by anyone with an account on the UNIX box ), I suggest you setup OS authenticated login for a particular UNIX account, then run your scripts from there. That way your command line would just contain a slash (/), which helps nobody break into your database.

sqlplus / @script will allow the current UNIX user to log in to the instance as long as an OS authenticated oracle user has been defined with the same name ( prefixed by the setting of os_authent_prefix in the init file ).

This makes for a much more secure execution environment in the long run.

-Kevin
<jpebejer_at_maltanet.net> wrote in message news:8ra9ud$nju$1_at_nnrp1.deja.com...
>
>
> I have a script (myscript.sql) which I want to run AUTOMATICALLY each
> time from the shell through some sort of scripting (on a UNIX box).
>
> Aren't there some command line parameters to do this ?
> Say SQL*Plus myscript.sql ?
>
> Many Thanks
> JP
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 02 2000 - 15:22:56 CDT