Symptom
- 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".
Read more...
Environment
SAP on IBM DB2 for Linux, UNIX, and Windows
Keywords
SCHEMA USER, sap<sid>, sapr3, db<sid>mnt, id sap<dbsid>, user group , KBA , db2 , schema user, sap
About this page
This 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.
SAP Knowledge Base Article - Preview