Solution : https://service.sap.com/sap/support/notes/25591 (SAP Service marketplace login required)
Summary :
This SAP Note guides users on changing passwords for various database user types in systems running SAP MaxDB version 7.6 or higher. It details the prerequisites such as using the latest versions of Database Manager GUI/SQL Studio and outlines procedures for password changes for DBM users, SYSDBA, and DBA users. Different user roles, including the main administrative 'control' and 'superdba', are described with specific commands for password updates either via the Database Manager GUI or CLI. It emphasizes ensuring system state appropriateness (OFFLINE for DBM user changes and ONLINE for SYSDBA) and advises on syncing changes across user interfaces.
Key words :
database manager gui/sql studio/database studio, sql studio/database studio/database manager gui, loaded usingconfiguration -> upgrade systemtables important, create user sapr3 password sap dba, error message-24909 sysdba unknown [load_systab, -24988 sql error [sql_execute alter user, database manager gui call, sql studio/database studio, configuration -> dbm operator -> select, database core versions lower
Related Notes :
| 700659 | Security Guide: mySAP Supply Chain Management |
| 607082 | No connect after 'Disabled' indicator activated for DBM user |
| 386714 | SQL Studio and Database Manager GUI installation |
| 39439 | XUSER entries for SAP DB and MaxDB |