Install with backup/restore - with wrong "ABAP Connect User" - Change possible?

[teddylv_andersen2]

Hello Sappies.

I by mistake Installed a system using the wrong "ABAP Connect User".

Backup/restore method used.

Is it possible to change the owner of all objects(tables, views,????) owned by the wrongly specified user?

Best regards,

Teddy

[maria_shen]

Hello Teddy,

To change the schema of objects (tables, views) is not supported in general.

Instead, you may consider to correct the wrong 'ABAP connect user'.

SAP note 713524 describes the details.
713524 - DB6: Additional information on system copy with DB resources

<Quote>

• Create the correct connect user in the system.
• Set the 'dbs/db6/schema' SAP profile parameter in the instance profile of all SAP instances in the system to this connect user.
• Set the 'dbs_db6_schema' environment variable to the connect user for the <sapsid>adm and db2<dbsid> users.

<End>

Hope it helps.

Kind regards
Maria

[teddylv_andersen2]

Hallo Maria.

I am completely aware of the facts about the schema and the profile parameter and environment variable was set correctly.

The issue was when installing the system, I by mistake specified db2<sid> as the ABAP Connect User and not sap<sid> as it should have been.

therefore the owner of tables, views, ?, ? was set to db2<sid> and that isn't what's expected when running an upgrade of the system.

Best regards,

Teddy

[maria_shen]

Hallo Teddy,

Then the official way is to start from scratch. I understand that perhaps you consider to use TRANSFER OWNERSHIP command to change the owner of the objects. But  there are more things done in the sapinst code, as far as my understanding.

Kind regards
Maria