SQL1092N DB2SID does not have the authority to perform the requested command

Case

You perform in SAP some actions which should access to the dabatase but it brings following error:

SQL1092N “DB2<SID> ” does not have the authority to perform the requested command

Solution

The Os-group of user must be assigned to Admin-Group in Db-level

Check auth&groups at db level by command:

db2 get dbm cfg

You get something similar as follows:

SYSADM group name (SYSADM_GROUP) = DB<SID>ADM

SYSCTRL group name (SYSCTRL_GROUP) = DB<SID>CTL

SYSMAINT group name (SYSMAINT_GROUP) = DB<SID>MNT

Please update dbm via command:

db2 update dbm cfg using SYSADM_GROUP etc <group name>

Leave a Reply