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

[Arun Kumar <arunkumar13@yahoo.com>]

Again security concern:
Input command is not encrypted. 
It will display the password when user types it.
The sqr can be used (accused) to collect user's passwords. 

HTH

----- Original Message ----
From: Dwight Schrute <schrute.dwight@hotmail.com>
To: sqr-users@sqrug.org
Sent: Tuesday, January 23, 2007 4:40:15 PM
Subject: RE: [sqr-users] Call System & using existing DB connection

Suggestion:  Create a input variable called $password and populate it when 
you call your first report.  Then use that in the creation of the connection 
string for the second report.


>From: "Peter Burton" <Peter_Burton@hyperion.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reportinglanguage 
>fromHyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Call System & using existing DB connection
>Date: Tue, 23 Jan 2007 16:34:47 -0500
>
>Kim,
>
>Nope ... At least not from Hyperion SQR.
>
>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 Kim Meyrowitz
>Sent: Tuesday, January 23, 2007 4:07 PM
>To: sqr-users@sqrug.org
>Subject: RE: [sqr-users] Call System & using existing DB connection
>
>Understand that, but since I am already connected in my calling sqt
>...anyway to pass that same connection info on to the sqt I need to call
>via
>the call system command?
>
>
> >From: "Peter Burton" <Peter_Burton@hyperion.com>
> >Reply-To: "This list is for discussion about the SQR database
> >reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
> >To: "This list is for discussion about the SQR database
>reportinglanguage
> >fromHyperion Solutions." <sqr-users@sqrug.org>
> >Subject: RE: [sqr-users] Call System & using existing DB connection
> >Date: Tue, 23 Jan 2007 15:55:52 -0500
> >
> >
> >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=hmemt
>a
> >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
>
>_________________________________________________________________
>Get Hilary Duff's homepage with her photos, music, and more.
>http://celebrities.live.com
>
>
>_______________________________________________
>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

_________________________________________________________________
Search for grocery stores. Find gratitude. Turn a simple search into 
something more. 
http://click4thecause.live.com/search/charity/default.aspx?source=hmemtagline_gratitude&FORM=WLMTAG


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







 
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited

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