Receiving Log Analyzer for Db2 for z/OS message LAE0207E for table(s) where authorized:
LAE0207E User: xxxxxx is not authorized to select data from table creator.tablename
SECURITY (Y) is specified in the PLA member of hlq.CDBAPARM.
/* DB2 security enforcement ? */
/* (Y) DB2 security is enforced */
/* (N) DB2 security not enforced */
Component: Log Analyzer for Db2 for z/OS
Log Analyzer requires the DSN3@SGN exit to obtain a list of secondary IDs for a primary ID in order to successfully resolve the
users access privileges if SECURITY (Y) is set within the PLA member of hlq.CDBAPARM.
If this exit is not in the LOADLIBS concatenation in SETUPxx member of hlq.CDBAPARM, Log Analyzer will not have access to DSN3@SGN.
Validate the Db2 LOADLIBS concatenation within the SETUPxx member in hlq.CDBAPARM library.