LAE0207E user not authorized to select data from table executing Log Analyzer.

Products

• Log Analyzer for DB2 for z/OS
• Database Management for DB2 for z/OS - Recovery Suite

Issue/Introduction

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   */

Environment

Release: 20.0
Component: Log Analyzer for Db2 for z/OS

Resolution

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.