SET CURRENT SQLID Violation

Document ID : KB000048027
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Getting the following message in DB2:

The authorization ID specified as the value of the authorization-id or host variable in the SQL SET CURRENT SQLID statement is neither the user's primary authorization ID nor one of the associated secondary authorization IDs.

The CA Top Secret TSSUTIL report shows a security violation for Resource Type of DB2SYS and Resource Name SYSADM.

Solution:

Grant user the following TSS PERMIT command:


TSS PER(xxxxx) DB2SYS(SYSADM) ACC(READ) 

Please be aware that SYSADM gives DB2 administrator authority. Please give this authority only to those who really need it.

Please refer to the CA Top Secret Command Functions Guide for more details about the TSS PERMIT command.