<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.shorttext
{mso-style-name:short_text;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='color:#1F497D'>Maybe you can set variables at
the OS level and use them with this code in the dictionary…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In windows I do this:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>REM Setup Oracle Database
Location (defined in tnsnames.ora)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>set ORACLE_SID=XE<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>REM Setup Oracle Database
User/Password (Login name in Database)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>set ORDBUSER=mydbuser<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>set ORDBPASS=mypassword<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>DATABASE
SYSTEMDB &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'> Type
ORACLE &<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'> NULL
VALUES NOT ALLOWED & ; NEVER set this to ALLOWED!!!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>
Owner SYSTEM & ; cannot be a variable!!!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'> OPEN
"ORACLE@%ORDBUSER%@%ORACLE_SID%/%ORDBPASS%"<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Other than this, I think you are
dead in the water on this one.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Tell your infra structure guy you
need to start using application security and allow access to the database the
way it was meant to be done with PH. Via one user/password in the dictionary.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Ken<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <b>On
Behalf Of </b>Birkmose, Anders<br>
<b>Sent:</b> June 16, 2010 9:50 AM<br>
<b>To:</b> powerh-l@lists.sowder.com<br>
<b>Subject:</b> [Bulk] Running PH and Database on different servers<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi all, <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>For infra structure reasons we have been ask to separate our
PH application and ORACLE Database into two different Linux Redhat servers. <o:p></o:p></p>
<p class=MsoNormal>But there is still a r<span class=shorttext><span
style='color:black;background:white'>equirement that each User most connect to
the ORACLE Database via PowerHouse with their own user/password. <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'><o:p> </o:p></span></span></p>
<p class=MsoNormal>Currently we are running on one AIX server, so we uses
the OPS$ option from ORACLE, where the user automatically are granted access, <o:p></o:p></p>
<p class=MsoNormal>as long as they are locally login to the AIX server. <span
class=shorttext><span style='color:black;background:white'><o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'>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. <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'>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. <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'>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. <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'>Any suggestion will be appreciated . <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'><o:p> </o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'>Many regards <o:p></o:p></span></span></p>
<p class=MsoNormal><span class=shorttext><span style='color:black;background:
white'>Anders </span></span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br
clear=all>
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 não imprimindo este correio electrónico. 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. <o:p></o:p></span></p>
<p><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>No virus
found in this incoming message.<br>
Checked by AVG - www.avg.com<br>
Version: 9.0.829 / Virus Database: 271.1.1/2940 - Release Date: 06/16/10
02:35:00</span><o:p></o:p></p>
</div>
</body>
</html>