Midrange News for the IBM i Community


Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
Chicagoland
SQL Connect To Using is Ignoreing User
has no ratings.
Published: 25 Jan 2013
Revised: 25 Jan 2013 - 1609 days ago
Last viewed on: 22 Jun 2017 (2665 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

SQL Connect To Using is Ignoreing User Published by: Bob Cozzi on 25 Jan 2013 view comments(1)

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Chicagoland
Comment on: SQL Connect To Using is Ignoreing User
Posted: 4 years 4 months 27 days 21 hours 11 minutes ago
Edited: Fri, 25 Jan, 2013 at 12:15:21 (1609 days ago)

Kept digging and found this; it is a two step process:

Step 1 is performed ONCE on each remote location connecting back to the host server:

CHGSYSVAL SYSVAL(QRETSVRSEC) VALUE('1')

Step 2 is performed ONCE for each User Profile that does NOT exist on the host server or that does NOT have *SECOFR user class:

ADDSVRAUTE USRPRF(XXXXX) SERVER(HOSTSRV) USRID(HOSTUSER) PASSWORD(HOSTPWD)

Of course 'HOSTSRV' is replaced with the remote database server name (must be in all upper case). HOSTUSER and HOSTPWD are replaced with the  user ID and PWD being used to connect to the host server.

 

But in the end, I'm still not happy with this solution. It means that in my RPG program I have to do a CONNECT TO XXXX User HOSTUSER Using :pwd; and if I wanted to connect using another user, I'd have to go add it to the SVRAUTE too. This just seems goofy to me.