RE: Client Access ODBC

It makes sense for an automated job to be able to sign itself into the
AS/400, otherwise our overnight SQL Server DTS job would need someone to
sign on for it every night at 8pm.

I got around it by using CA Express' ability to pass the NT username and
password to the AS/400 for validation. The service account SQL Server uses
to run the DTS job has an equivalent account on the AS/400 with the same
password and signs itself in OK. Only a person who knew the SQL Server
service account password could use this to gain access to the AS/400, and
these people have high level access to the AS/400 anyway.

Regards
 Gary


-----Original Message-----
From: alan shore [mailto:SHOREA@dime.com]
Sent: 10 April 2001 15:17
To: MIDRANGE-L@midrange.com
Subject: RE: Client Access ODBC


Im sorry, but I have to completely disagree. The situation here is NOT the
fact that an automated, tested job requires access, but you want to create
unrestricted access to a computer, (AS/400 or whatever). Every place I've
worked at , financial, manufacturing etc, the auditors would drag me into
their office and demand what the hell I was thinking of. And I quote, "Any
type of access REQUIRES some type of key to get in.Period end of story. end
of discussion". End quote. 
Believe me, been there, TRIED to do that (Failed miserably).

 


This e:Mail and any files transmitted with it are confidential and intended
solely for the use of the individual to whom it is addressed.
If you have received this e-mail in error please contact Matthew Middleton
or Gary Holliday immediately by telephone on 01775 710789 or on e-mail at
Smedleys.IT@Smedleys.co.uk
Any views or opinions presented are solely those of the author and do not
necessarily represent those of Smedleys Foods.
Unauthorised publication, use, dissemination, forwarding, printing or
copying of this e-mail and its associated attachments is strictly
prohibited. 


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---