Jim,
Reminds me of the Relational Database Directory entries I needed to make to
allow us to read-write MS Sql Server data from our iSeries. The command is
ADDRDBDIRE (Add RDB Directory Entry).
One good open-source solution is ARDGATE.
Once installed and configured we were able to use STRSQL, QM Query, and
embedded SQL to read-write to the remote DB.
HTH.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Muehe
Sent: Wednesday, May 22, 2013 1:37 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Service account
I need to create a "service account" on the iSeries. Did some Google searches, I am starting to think service account is the wrong terminology on the iSeries.
So to be clear, this account would be used in a connection string on a program on a non-iSeries box.
The account has to be able to read/write/update records and execute stored procedures on the iSeries.
I could just create a normal user profile, but I remember reading for security reason you should not for this type of account.
Help, what is the right way?
Jim Muehe | Sr. Programmer Analyst | CHEFS® | An Affiliate of ¤Target Corporation® | 5070 Centennial Blvd. | Colorado Springs, CO 80919
719.272.2618 (P) | 719.272.2624 (F) | www.CHEFScatalog.com <
http://www.chefscatalog.com/> | www.Target.com <
http://www.target.com/>
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
