Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 @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 - 08:21:21 CDT