Re: Oracle Security in Bourne Shell and Perl Scipts

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Tue, 23 Apr 2002 21:19:54 GMT
Message-ID: <3CC5CFEA.A0A90591@exesolutions.com>

Mahtaj Khamneian wrote:

> I sent this post last Thursday, but could not find it in the list of
> articles.
> My apologies if this has been posted before.
>
> I have setup and am maintaining several shell and perl scripts to
> perform some DBA tasks. So far, I have included the sys password in the
> scripts whenever I connect to Oracle. I am now trying to find a way to
> avoid the oracle password inclusion in the scripts.
> Anyone has experience in this area?
>
> I appreciate some pointers.
>
> -------------------------------------
> Mahtaj Khamneian
> University of Missouri - ASP Phone : (573) 884-2281
> 1805 East Walnut Fax : (573) 884-3070
> Columbia, MO 65201-6425 khamneianm_at_missouri.edu

Set up an operating system validated user with an OPS$ account. Give that user appropriate permissions on the database. And have that user run all scripts.

Daniel Morgan Received on Tue Apr 23 2002 - 16:19:54 CDT