We have a webapp (under apache) that needs to connect to
the database. Of course, since it starts up automatically,
we don't have a place where a user can type in a login
name and password.

An obvious solution is just to embed the name and
password as part of the connect string in the apache
config file:
DB_CONNECT_STRING=myname/mypass@myoracle

Is there a better way to do this?

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

Mark Harrison <mh@pixar.com> wrote in news:C0Dei.5809$c06.2741
@newssvr22.news.prodigy.net:

> We have a webapp (under apache) that needs to connect to
> the database. Of course, since it starts up automatically,
> we don't have a place where a user can type in a login
> name and password.
>
> An obvious solution is just to embed the name and
> password as part of the connect string in the apache
> config file:
> DB_CONNECT_STRING=myname/mypass@myoracle
>
> Is there a better way to do this?
>
> Many TIA!
> Mark
>

By using OS authentication, no password is needed.

"Mark Harrison" <mh@pixar.com> wrote in message
news:C0Dei.5809$c06.2741@newssvr22.news.prodigy.ne t...
> We have a webapp (under apache) that needs to connect to
> the database. Of course, since it starts up automatically,
> we don't have a place where a user can type in a login
> name and password.
>
> An obvious solution is just to embed the name and
> password as part of the connect string in the apache
> config file:
> DB_CONNECT_STRING=myname/mypass@myoracle
>
> Is there a better way to do this?
>
> Many TIA!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

If you are using Windows, you can encrypt and/or store connection string and
password in the registry.