Skip to Content
avatar image
Former Member

Unlocking user ID on EBPro 620

For some reason or another all users have been locked out of our sandbox system which happens to be an 620 EBPro system. Setting the uflag to 0 does not unlock the user. Can someone provide the syntax to unlock a user at the Oracle level for a 620 system?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 08, 2006 at 07:15 AM

    Hi,

    ALTER USER <user_name> ACCOUNT UNLOCK; this is general syntax to lnlock user

    but I am not unstding which user u want to unlock

    master users u can select from

    select username from dba_users;

    This will display Master DB and SAP users,

    let me know which users u want to unlock Because normal users in SAP will be in Difft table at DB.

    Regards

    Vinod

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2006 at 08:23 AM

    user is not locked => uflag = 0

    user is locked => uflag = 64

    log onto your server with ora<sid> (on unix) or <sid>adm (on windows):

    > sqlplus /nolog

    > connect / as sysdba

    > update sapr3.usr02 set uflag = '0' where bname = '<user id which is locked>' and mandt = '<client where user id resides>';

    > commit;

    should work... 😉

    GreetZ; AH

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      The User Locking mechanism was already present in Oracle9 but deactivated by default.

      To disable userlocking perform following commands

      sqlplus /nolog

      sqlplus> ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

      sqlplus> exit

  • avatar image
    Former Member
    Nov 15, 2006 at 06:14 AM

    Hi,

    first check out if u are able to access the USR02 table space...

    if u are able to access it the use

    alter table SAP<SID>.USR02 set UFLAG=0 where mandt=<client>;

    should wrk...

    thanks

    jag

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2006 at 10:49 AM

    HI,

    GO TO CMD PROMPT,

    TYPE SQLPLUS /NOLOG;

    SQL PROMPT WILL APPEAR

    TYPE CONNECT /AS SYSDBA;

    UPDATE SAP<INSTANCE ID>.USR02 SET UFLAG='0' WHERE MANDT=<'CLIENT NO'> ;

    COMMIT;

    AS FOR EX

    UPDATE SAPD01.USR2 SET UFLAG='0' WHERE MANDT='200';

    COMMIT;

    THIS WILL HELP.

    PL AWARD A POIT IF WORKS

    REGARDS

    Add comment
    10|10000 characters needed characters exceeded