Below is the query for resetting the flag
UPDATE prd.USR02 set UFLAG = ’00′ where MANDT = ’000′ and bname= ‘DDIC’;
Here prd is the database name; UFLAG is the field which we need to set to 0, MANDT represents in which client the login belongs to and BNAME is the field which contains logins. If you want to reset the flag for SAP* when it gets locked then replace DDIC with SAP* in above query.
or
1) Login to database using / as sysdba
2) select aname from sapsr3.usr02 where mandt=000;
3)delete from sapsr3.usr02 where aname=’SAP*’ and mandt=000;
0 nhận xét:
Đăng nhận xét