Re: auditor access

[Jerry Draper <midrangel@xxxxxxxxxxxxx>]

Here's an interesting menu delivered by IBM for audit purposes.

GO SECBATCH

Jerry

On 9/25/2017 11:57 AM, Rob Berendt wrote:
> It was also requested that I send them who had access to the schema list
> so I added this to the audit.
>
> create table schemalist as (
> select *
> from QSYS2.OBJECT_PRIVILEGES
> where system_object_schema ='QSYS'
>    and system_object_name in('ERPLXF', 'ERPLXUSRF')
>    and object_type ='*LIB'
> ) with data;
> CL:  CPYTOIMPF FROMFILE(SCHEMALIST)
>            TOSTMF(SCHEMALIST.csv)
>            MBROPT(*REPLACE)
>            STMFCCSID(*PCASCII)
>            RCDDLM(*CRLF)
>            ADDCOLNAM(*SYS);
>
>
> Rob Berendt