Re: Connecting to the iSeries DB using a user with no password

Martin,

Setting a service profile to password *NONE seems reasonable but I
would agree it should be enabled even if enablement is scheduled or part
of the startup for the job. You can use the current user profile when
you are using the native driver. If you need to set the profile to
something different, you can swap the thread for the connection using
the set effective user API but you have to have *ALLOBJ authority or be
authorized to the profile you are swapping to. You can set your thread
to a disabled profile however disabled profiles can encounter authority
failures in some cases (maybe changing the group or supplemental
group?).

David Morris

>>> martin.mccallion@xxxxxxxxx 5/21/2004 9:29:52 AM >>>
Hi all.

Our application has to integrate with another application which submits
our
server job as a batch job.  Now the other application runs its batch
jobs
under a paranoid level of security, in that the user profile it runs
batch
jobs under has its password set to *NONE (I think it is also disabled,
which
to my mind ought to mean that it shouldn't run the batch job, but
that's
another story).

So our app has to run under that user.  Now I've modified our data
queue
access so that such a user works, based on Dave Wall's post from the
archive: http://archive.midrange.com/java400-l/200204/msg00024.html.
Basically you call the AS400 constructor with no parameters, and then
you
_don't_ call system.connectService(AS400.DATAQUEUE).  So our data
queue
connections now work.

But I also have to make _database_ connections work.  So in short, is
there
any way to make a database connection (using either toolbox or native
driver) using a user profile with password *NONE?

Cheers,

Martin.