SAP Knowledge Base Article - Preview

2946503 - Transfer ownership of a database object fails with sql error SQL20342N

Symptom

While performing an operation within Dbacockpit or during an upgrade you observe the following SQL0551N error:

LINE.jpg
"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.
LINE.jpg

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:

LINE.jpg
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.
LINE.jpg


Read more...

Environment

Db2 releases prior to 11.1 Mod 4 Fixpack 5

Product

SAP NetWeaver all versions

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.