SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

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

Your email address will not be published.

Related topics

Exception while creating JCo client connection

During creating JCO connections in SAP Netweaver Admin (nwa) you get following error:   Exception while creating JCo client connection Failed to create new JCO […]

No main memory available twrtab reached memory limit during tp

Case: During Client import you get an error something like that: No main memory available (42500000) twrtab reached memory limit; memory usage 42000000 139596 entries […]

SQL error 2220 ORA 02220 invalid MINEXTENTS storage option value

Case The creation of an index terminates with the Oracle error “ORA-02220: invalid MINEXTENTS storage option value”. During the transport, during the Support Package import, […]

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 […]

Class not found: com.sap.engine.offline.OfflineToolStart

During a Sap J2EE installation you get following error: The java class is not found: com.sap.engine.offline.OfflineToolStart Solution There two options: (A) remove this JVM option […]