|
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
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
