Skip to Content

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

changing passwords and system copies

Hello,

since we are changing passwords of the users control, superdba and database schemata user to individual passwords we get problems with system copies.

When we do a system copy and try to set the password of the superdba we get the message wrong sysdba.

We can connect to a copied database by two different passwords to database instance (dbmcli uses the origin of the system, dbmgui the password of the source system of system copy).

Is the passord of superdba stored at two points, filesystem and in the database?

At FAQ I found the hint to load systab after installation, upgrade and system copy.

Can I load systab at any time without risk?

Best Regards

Andreas

Former Member
replied

With loading the system tables the password is updated in the UPC file. As long as a wrong password is stored there, the dbmserver does not allow connecting with this user. But you should always load the system tables after you created a system copy, anyway.

Regards,

Melanie

0 View this answer in context

Helpful Answer

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