How to unlock DDIC & SAP* user in 000 client-Sybase database

[Former Member]

Dear Experts,

   Accidentally DDIC and SAP* user in 000 client has locked. We are using SYBASE ASE database. I know how to unlock user in other database (eg:update <sid>.USR02 set UFLAG = 0 where BNAME = '<user id>'' and mandt = <clinet number>;).

   what is the equal query in Sybase.

Thanks, Jyothish

[former_member188883 · Accepted solution]

Hi Jyothish,

Please try below commands

Login to Sybase ASE database using

isql -Usa -S<SID>  ( it will prompt for password)

use <DBSID>

To check the account status

select UFLAG from USR02 where BNAME ='SAP*' and MANDT='000'

go

To unlock the account

update USR02 set UFLAG=0 where BNAME='SAP*' and MANDT='000'

go

You may add schema owner SAPSR3.USR02 in the query if above query does not work.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks Deepak, its worked. i could unlock the user

[Former Member]

Hi Jyothish,

To unlock user ids:

UPDATE SAP<SID>.usr02 SET flag=0 WHERE bname="*user id*" AND mandt=client number;

Regards,

Gireesh