RE: [sqr-users] DataBase Security and Logins!!!!!

["David Brawner" <dbrawner@att.net>]

Scott,  we've always included a $schema input parameter, and all table
references are coded like;

select distinict
ponum

        Do some-procedure

from [$schema]tablename
where itemnum like $itemnum_param
end-select

If you don't want to make it an input variable, and you're always going to
run the .sqt against the same databases, add the line;

let $schema = {schema_name.}

and don't forget the . after the schema name.

We include this as an input parameter passed via a prm file because our
reports are often run on multischema databases.

Dave



-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Scott Eubank
Sent: Tuesday, May 13, 2003 4:01 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] DataBase Security and Logins!!!!!



 Hi all,

  We have an issue posed by our Audit Team.

  We are on DB2 and are running Psoft 7.5.

  Currently we all LOGIN via telnet to our development box as, say, HRDEV
the database instance name.   Audit wants UNIQUE user names and passwords
for each USER who wants to run SQR's from the command line in Development.
This is a problem at compile time becuase SQR tries to resolve the DataBase
Scheme name to the USERS NAME ( ex. SCOTT.PS_HR_TABLE).  This causes our
compiles to fail everytime, again and again.  We need to have the COMPILE to
Resolve the to the Database scheme name.

DOes ANYONE have a way to resolve this problem?
I am assuming that you would need to made do it with some kind of script
that launches prior to the SQR compile or something in an SQC you could
easily include in your files.

THanks,
Scott

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

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