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.