Running PH and Database on different servers

[Birkmose, Anders]

Hi all,

For infra structure reasons we have been ask to separate our PH application and ORACLE Database into two different Linux Redhat servers.
But there is still a requirement that each User most connect to the ORACLE Database via PowerHouse with their own user/password.

Currently  we are running on one AIX server, so we uses the OPS$ option from ORACLE, where the user automatically are granted access,
as long as they are locally login to the AIX server.

So our issue is, how do we connect via the PH Dictionary to the from PH application server to another database server, when each user most have their own user/password in the database.

We don't want the user to type in user/password each time they should attach to the database. The users also starts a lot of background job, running in the own Shells, so where it will not be possible for them to type database user/password.

One top of everything, we have also been ask to implement AD (Active Directory), but that is another issue, which brings up a lot of other challenges.  Right now our focus is on splitting the application and Database, and still have the users there own database user.

Any suggestion will be appreciated .

Many regards
Anders



Please help Logica to respect the environment by not printing this email  / Pour contribuer comme Logica au respect de l'environnement, merci de ne pas imprimer ce mail /  Bitte drucken Sie diese Nachricht nicht aus und helfen Sie so Logica dabei, die Umwelt zu schützen. /  Por favor ajude a Logica a respeitar o ambiente nao imprimindo este correio electronico.



This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100616/6e98f481/attachment.htm