Unlock SAP* and DDIC users in MaxDB

[Former Member]

Hi,

Does anyone know how to unlock SAP* and DDIC user MaxDB? I tried using the following "<b>delete from SAPV01.usr02 where mandt='000' and bname='SAP*'.</b>" string in SQL Studio (ie having connected to the database) but it's returning the following error message:

-

---

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Syntax error or access violation;-3014 POS(60) Invalid end of SQL statement

delete from SAPV01.usr02 where mandt='000' and bname='SAP*'.

Very many thanks in advance.

Reuben.

[Former Member]

Hi,

Please, check the below thread,

Thanks

R.Murali

[Former Member]

Hi Murali,

I ran the following command (sqlcli -U DEFAULT " delete from usr02 where mandt='000' and bname='SAP*' ") which I got from the link you recommended, and it didn't work; it returned the following sqlcli error message -

-

---

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Syntax error or access violation;-3005 POS(1) Invalid SQL statement

<b>sqlcli</b> -U DEFAULT " delete from usr02 where mandt='000' and bname='SAP*' "

Reuben.

[Former Member]

Delete SAP*

sql_execute delete from sapr3.USR02 where BNAME='SAP*' and MANDT=u2019000u2019

[Former Member]

These threads you are bouncing are from 2007...

Cheers,

Julius