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

["Suman Buddharaju" <SBUDDHA@dot.state.tx.us>]

Modify the SQC to execute the following command

SET SCHEMA=[DBNAME]

By default a user id schema is the userid.  By executing  the above
command you are setting the schema of all the user who run SQR to
one command thing.  Then your SQR should find the tables.


>>> SEUBANK@advance-auto.com 05/13/03 03:00PM >>>

 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