× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Rick

I believe the data structure has been extended to include the current user,
so check the latest version of the docs for more details

cheers
Colin.W

On 11/05/06, Rick DuVall <R_C_DuVall@xxxxxxxxxx> wrote:

Hi Colin,

       Thanks for your response. I am concerned with the user id that my
db
triggers show which is gotten from the program status data structure as in
:
    D                SDS
    D PgmNam            *PROC
    D UserId                254    263

       Which works for all current native accesses.  How would I find the
'Current
User' at the trigger level?

Regards,

Rick DuVall
Systems Manager
Dealer's Auto Auction of Okc
1028 S. Portland
Oklahoma City, OK 73108
(405) 947-2886
rick@xxxxxxxxxx

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Colin Williams
Sent: Thursday, May 11, 2006 9:09 AM
To: Java Programming on and around the iSeries / AS400
Subject: Re: QUser and jdbc access to os400


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

--
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.