- 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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.