RE: [sqr-users] Call System & using existing DB connection

["Peter Burton" <Peter_Burton@hyperion.com>]

The only reason why the password is not made available inside of the
program is because of SECURITY concerns.

Peter

-----Original Message-----
From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
[mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org] On Behalf
Of Arun Kumar
Sent: Tuesday, January 23, 2007 3:48 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] Call System & using existing DB connection

Hi,
There must be compelling reasons why sqr doesnt make password available
within the program.
They do hae many reserved variable like
$username,$sqr-platform,$sqr-connected-db but not the password.

Anyway, 

If you are running in Peoplesoft environment you might be able to pass
the password (%ACCESSPSWD%)  as one of the command line parameters and
use it to call the SQT.

If you do figure out please share it...


HTH...


----- Original Message ----
From: Kim Meyrowitz <kmeyrowitz@hotmail.com>
To: sqr-users@sqrug.org
Sent: Tuesday, January 23, 2007 1:42:54 PM
Subject: [sqr-users] Call System & using existing DB connection

I currently have 1 sqt that calls another sqt using the Call System
command.

Problem is I need to pass the username,password and database info (using

Oracle). I can get the username from the $username variable & the
database 
by querying to see which db I am currently attached to, but how do I get
the 
password?

I can not hardcode this info because we run this file on different
instances 
so everything does not stay the same.

Thanks in advance!

_________________________________________________________________
Turn searches into helpful donations. Make your search count. 
http://click4thecause.live.com/search/charity/default.aspx?source=hmemta
gline_donation&FORM=WLMTAG


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users







 
________________________________________________________________________
____________
Sucker-punch spam with award-winning protection. 
Try the free Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/features_spam.html

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. Internet communications are not secure and Hyperion does 
not, therefore, accept legal responsibility for the contents of this message 
nor for any damage caused by viruses. The views expressed here do not 
necessarily represent those of Hyperion. For more information about Hyperion, 
please visit our Web site at: www.hyperion.com



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users