RESET DBA user password

[Former Member]

Dear Community,

Please tell me, where is mistake?

I try to reset password of DBA user SAPR3 using sqlcomand:

sqlcli -d SDB -u superdba,superdba ALTER PASSWORD SAPR3 SAPR3

but it not work and i recive answer of the system like :

0 rows affected (3772 usec)

Please help/

[Former Member · Accepted solution]

Hello Albert,

your password has been altered. You can ignore the message. For DDL commands the row count

isn't set and will display '0 rows affected'

check the password change with

sqlcli -d SDB -u SAPR3,SAPR3 select user from dual

Regards,

Burkhard

[Former Member · Accepted solution]

It seems like it is ok, can you give somthing more comands for checking SAPR3 user new password?

[Former Member · Accepted solution]

Thanks for response. You`re right

[Former Member]

Hi Albert,

I didn't know a DBA user with the name SAPR3 in MaxDB. But there is a user SAP<SID>.

Maybe that is the mistake?

Regrads

Matthias