DB2 SET CURRENT SQLID receives Top Secret security violation.

Products

• Top Secret

Issue/Introduction

 Receiving 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 Top Secret TSSUTIL report shows a security violation for Resource Type of DB2SYS and Resource Name SYSADM.

 

 

Resolution

Grant user the following TSS PERMIT command:

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

which grants the user DB2 administrator authority.  

Additional Information

See Top Secret section DB2SYS Resource Class—Secure DB2 Privileges and Authorities