Re: Auditing users with elevated privileges.

[Bryan Dietz <bdietz400@xxxxxxxxx>]

or use SQL  :-)

SELECT Authorization_Name
       ,Job_Name
       ,Subsystem
    FROM TABLE (
            Qsys2.Active_Job_Info()
        ) I
    WHERE Authorization_Name = 'ROB'
;


Jim Oberholtzer wrote on 7/10/2019 10:07 AM:
> Nice, I had not thought of using the user profile lock to see active jobs.
>
> Thanks for the ideas!
>
>
> --
> Jim Oberholtzer
> Agile Technology Architects
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob
> Berendt
> Sent: Wednesday, July 10, 2019 8:22 AM
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: RE: Auditing users with elevated privileges.
>
> I like the audit journal.  For this project I can't see anything that
> history log brings to the table that I can't get from the audit journal.
> Maybe job start and end but I'm not concerned about those as I can use the
> ENTRY_TIMESTAMP for what I need.
>
> If I was looking for just active jobs I would look for locks on the user
> profile with select job_name from qsys2.object_lock_info where
> system_object_name = 'ROB'
> and OBJECT_TYPE = '*USRPRF';
>
>
> Rob Berendt