Symptom
While performing an operation within Dbacockpit or during an upgrade you observe the following SQL0551N error:
"SQL code: -551" occurred while accessing table "<table|view name>"
"SQL message: SQL0551 The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation.
Authorization id:"SAPSID". Operation "SELECT". Object:"<table|view name>". SQLSTATE=42501.
To correct the error above you execute the steps outlined in the following KBA:
2773002 - Db2: Transfer Ownership of a database object
But then the 'transfer ownership' command fails with the following SQL20342N error:
TRANSFER OWNERSHIP OF VIEW "<view name>" TO USER SAPSID PRESERVE PRIVILEGES
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL20342N "SAPSID" does not have one or more required privileges "READ" on
object "LANGU" of type "VARIABLE" necessary for ownership of the object.
Read more...
Environment
Db2 releases prior to 11.1 Mod 4 Fixpack 5
Product
Keywords
-551 -20342 , 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.