SAP Knowledge Base Article - Preview

3606747 - DB6 - SWPM - Export Preparation - SELECT RELEASE, EXTRELEASE FROM SAP<SID>.CVERS WHERE COMPONENT = 'SAP_BASIS' - SQL0551N  

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

SAP NetWeaver 7.5

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.