Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database Object Ownership - change to DBO?

I am a DBA, not a Business Objects person. We have a Business Objects XI R2 installation running on MS SQl Server 200 SP4. There are a number of objects created in the Business Objects databases (not the user databases) that were created by either the installation and or subsequent where the owner of the database and tables are set to bo_user.tablename instead of dbo.tablename. I have been tasked with migrating all database objects to be owned by the dbo schema. What pitfalls do I need to watch outfor within business objects when I change the object ownership underneath the business objects platform. Or is there a way to do it via the Business Objects front end?

Some examples:

Database Object Owner

bobj_XIR2 CMS_InfoObjects5 bo_user

bobj_XIR2 CMS_Aliases5 bo_user

bobj_XIR2 CMS_IdNumbers5 bo_user

bobj_XIR2 CMS_VersionInfo bo_user

bobj_XIR2 CMS_RELATIONS5 bo_user

BusinessObjectsMetadata ci_ext_security bo_user

BusinessObjectsMetadata set_sync bo_user

BusinessObjectsMetadata set_profile bo_user

BusinessObjectsMetadata ipm_aclpolicy bo_user

Thanks!

David Hay

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question