Symptom
Please note:
Where <SID> is shown in the examples below, any testing will require <SID> to be replaced with the system SID before executing the commands.
The following statement fails in SWPM Export Preparation phase.
SELECT RELEASE, EXTRELEASE FROM SAPSR3.CVERS WHERE COMPONENT = 'SAP_BASIS'
SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.
Authorization ID: "DB2<SID>". Operation: "SELECT". Object: "SAP<SID>.CVERS". SQLSTATE=42501
Test the select from the OS level with the same db2<sid> user
db2 "SELECT * FROM SAP<SID>.CVERS";
The SQL0551N is also returned.
Read more...
Environment
Db2 LUW IBM
BC-DB-DB6
BC-INS-SWPM
Product
Keywords
KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem
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