How to Reset SAP* password in a MCOD system with HANA database?

[Former Member]

In an  MCOD System (HANA db) , How to reset sap* password?

we have mcod system , having schemas sapabap1 and sapabap2.

I want to reset sap* password in schema sapabap2.

Using saphana studio and user SYSTEM , I am running sql command "  delete from sapabap2.USR02 where BNAME = 'SAP*' and MANDT='000' .

I am getting error "

Could not execute 'delete from sapabap2.USR02 where BNAME = 'SAP*' and MANDT='000''

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

what privilege does this sql command required?

[isaias_freitas · Accepted solution]

Hello,

The HANA user "SYSTEM" is not allowed to change data in the application schemas .

Execute the same SQL, but with the HANA user that is the owner of "sapabap2".

Regards,

Isaías