Re: sqlplus problem

I understand the security concerns but in my particular case the only individuals who have access to unix logins also have access to all oracle passwords - in addition we are behind a firewall. My only concern is in regards to the sort area size problem.

Ken

WolfAlpha wrote:

> Just wanted to give you a little heads up that if you call sqlplus like that
> with a long running batch script, you will be compromising the security of
> that login account. Anyone else on that Unix box can do a ps -ef|grep
> sqlplus to see the command and all arguments (including the scott/tiger).
> If you want a more secure script, use sqlplus -s /NOLOG _at_rpt1 and on the
> first line of rpt1.sql put the following line:
>
> connect scott/tiger
>
> (or whatever user/password you need). Then chmod the file to restrict read
> privileges on it.
>
Received on Wed Jul 07 1999 - 15:21:21 CEST