- Symptom 1
In the process of upgrading system from Netweaver 7.30 to 7.50. following SQL1092N error appears:
tp_exec_statement: SELECT A,B,C,D FROM ( SELECT 'StoInfo:' A, DB_NAME B, DB_STORAGE_PATH C, STO_PATH_FREE_SIZE/1024/1024 D FROMTABLE( SNAP_GET_STORAGE_PATHS( '' , -2 )) AS STO_SNAP ORDER BY DB_NAME, DB_STORAGE_PATH ) AS Y
TPERR- SQL1092N The requested command or operation failed because the user * does not have the authority to perform the requested command or operation. User * "SAP<sid>"
- Symptom 2
Work process trace file contains error SQL1092N:
dsql_db6_fetch( SQLFetch ): [IBM][CLI Driver][DB2/AIX64] SQL1092N The requested command or operation failed because the user ID does not have the authority to perform
the requested command or operation. User ID: "SAPR3".
SAP on IBM DB2 for Linux, UNIX, and Windows
SCHEMA USER, sap<sid>, sapr3, db<sid>mnt, id sap<dbsid>, user group , KBA , db2 , schema user, sap
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.