- Below error can be seen in the transfer_ownership_SAP<SID>_tables.log while doing system copy using SWPM(Software Provisioning Manager).
transfer ownership of table "SAP<source sid>"."OII_DIP_PARAM" to user SAP<target sid> 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:
SQL0552N "DB2<target sid>" does not have the privilege to perform operation "TRANSFER OWNERSHIP". SQLSTATE=42502
- From SAPinst_dev.log:
The step transfer_ownership with Step Key
First error is : <SQL0552N "DP2SID"does not have the Privilege to perform operation "TRANSFER >?.
" on operation "TRANSFER OWNERSHIP""> Read more...
IBM Db2 => 9.7 and above.
SAP enhancement package 2 for SAP NetWeaver 7.0
Backup, Restore, SECADM, SYSADM, Authorization, Security, DBADM, Privilige, Perform , KBA , BC-DB-DB6-DBA , Database Administration , Problem
About this pageThis 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.