How to rename the owner of the database -MaxDB / Live Cache

[Former Member]

Dear Gurus,

How can I rename the owner of the database.

Example owner of the file systems in /sapdb from sdbap2 to sdbap1 (as part of my SID renaming process)

(Users are already created in OS level)

AIX 5, SCM 4.1, LC 7.5

Thanks,

Naren

[former_member204746 · Accepted solution]

you need to run an homogeneous system copy using SAPINST/R3LOAD.

if using MaxDB 7.6:

you can rename schema:

http://archives.neohapsis.com/archives/dev/sapdb/2005-q3/0297.html

[Former Member]

Thank you Natalia, I'll go and try this and let you know

Thanks & Best Regards

[former_member229109]

Hello Naren,

Please review the document "Interactive Installations/Update on UNIX" at :

http://dev.mysql.com/doc/maxdb/en/97/cf1fe0c62511d6b2b100508b5d5211/content.htm

&& check the section

"During the installation, the database software must be assigned to a

special operating system user <sdb_user>, who is the owner of the software,

and to the group <sdba_group>. ..." < as of the database version 7.5 >

Also see the document "Special Operating System Users and Groups (UNIX/Linux)" at

http://dev.mysql.com/doc/maxdb/en/23/cb4440eff00272e10000000a155106/frameset.htm

For SAP systems, we recommend you to use the sdb and sdba names for the

<sdb_user> owner and the <sdba_group> group.

The <sdb_user> owner user is locked. And if you would like to administrate the liveCache instance at Unix level, you need the user in the group sdba ( <sdba_group> ). So if you would like to change the name of the database administrator in SAP systems from user1 to user2, for example, you need to add the user2 to the group group sdba & remove the user1 from the members of the group sdba.

As one of the options to rename the owner of the database software you could run the following steps using the backup/restore procedure< SAP note 457425 > :

-> Create the complete data backup;

-> Uninstall the database instance using the sdbuninst tool

( SAP note 599129 )

-> Install the liveCache software using the SDBINST tool or CD and

select the new database owner sdbap1 during installation.

Then recreate the liveCache instance for the restore using DBMGUI, and run

restore after the backup medium pointed to the databackup will be created.

Thank you and best regards, Natalia Khlopina