DBA password change does not work

[Former Member]

Hi All,

I try to change the password of a DBA user SAP<SID>DB as described in Note 25591 - Password change for DBM and DBA users

I'm able to logon to the database with dbmcli and user SUPERDBA (that is in Role SYSDBA).

Once I try to execute:

>sql_execute ALTER PASSWORD SAP<SID>DB newPwd

I get the SQL Error:

-5001: Missing priviledge:OWNER

What is wrong?

Thanks for any hint.

Johannes

[former_member229109]

Hello Johannes,

-> What is the version of your database?

-> Please update with output of SQL statement "select * from users"

-> Connect as SAP<SID>DB or SYSDBA user first:

dbmcli -d <SID> -u control,<pwd>

>sql_connect SAP<SID>DB,<pwd>

>sql_execute ALTER PASSWORD SAP<SID>DB newPwd

>exit

Regards, Natalia Khlopina