Re: QUser and jdbc access to os400

["Colin Williams" <colinwilliams007@xxxxxxxxx>]

Rick,

QUSER is the user shown on WRKACTJOB, but there is also the current user,
which will be the profile that initiated the connection.

I believe from V5R4 the current user will also be shown on WRKACTJOB, and
not just QUSER

For audit purposes you need to pick up the current user

cheers
Colin.W


On 11/05/06, Rick DuVall <R_C_DuVall@xxxxxxxxxx> wrote:
> Hi Everybody,
>
>        I am experimenting with interactive java clients for accessing
> os400 data.
> One thing that strikes me immediately is that even if I open up jdbc
> access
> to the box,  which I can do on a userid level, all updates/inserts to the
> DB
> are attributed to QUSER no matter what userid/password is used to initiate
> the connection. We carefully track DB modifications on the userid level
> and
> this invalidates all that.  Am I missing something?  This seems kinda
> lame.
> I suppose unless someone can show me my error, I will use a back end rpg
> server that spawns off jobs using sockets under the incoming Userid to
> manage the db updates.  So, am I missing something here?  What is the best
> practice?
>
> Thanks!
>
> Rick DuVall
> Systems Manager
> Dealer's Auto Auction of Okc
> 1028 S. Portland
> Oklahoma City, OK 73108
> (405) 947-2886
> rick@xxxxxxxxxx
>
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.