IBM Support

SQL1092N authorization-ID does not have the authority to perform the requested command or operation.

Troubleshooting


Problem

SQL1092N may be thrown for few DB2 commands even though user has appropriate authority for that command or operation.

Symptom

Following error will be throw in this case:

$/home/db2inst1>db2 list application
SQL1092N "db2inst1" does not have the authority to perform the requested command.

Following DB2 command too may hit with above error:

GET DATABASE MANAGER MONITOR SWITCHES
GET MONITOR SWITCHES
GET SNAPSHOT
LIST ACTIVE DATABASES
LIST APPLICATIONS
LIST DATABASE PARTITION GROUPS
LIST DCS APPLICATIONS
LIST PACKAGES
LIST TABLES
LIST TABLESPACE CONTAINERS
LIST TABLESPACES
LIST UTILITIES
RESET MONITOR
UPDATE MONITOR SWITCHES

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Authorization\/Privilege","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"9.7;9.5;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

swg21591313

Page Feedback