BASIS GURU

CONCEPTS | BASICS | HOWTO

  • Home
  • SAP
    • SAP BASIS
    • SAP SOLMAN
    • SAP SECURITY
  • DATABASE
    • ORACLE
    • SAP HANA
    • SAP ASE
    • MSSQL
  • OPERATING SYSTEM
    • WINDOWS
    • LINUX-UNIX
  • SAP ON CLOUD

Unlock SAP User At Database Level

admin DATABASE, ORACLE 0

www.basisguru.com

Sometimes we might be in the situation,when all the SAP users are locked even the DDIC and other admin users.
In such cases, We can use the traditional method of unlocking SAP* user.
However it will require database bounce and is also a time-consuming task.
Today we will discuss how we can unlock the SAP users at oracle database level.

Suppose we need to unlock SAP user ‘TEST1’ from both 200 and 400 client.

Let us discuss step by step how to achive it at database level.All we need is the sqlplus/sysdba access to database:

Step 1

Login as <orasid> and goto SQLplus: and issue below query to see the users in the system DEV
Here assume Database host =sapdev.

select bname,mandt from sapdev.usr02 where bname='TEST1';
unlock SAP user at database level
Display SAP users via database

Step 2

To unlock user TEST1 in client 200, set UFLAG=0 with below query:

SQL> update SAPDEV.USR02 set UFLAG = 0 where BNAME = 'TEST1' and mandt = 200;
SQL> commit;
unlock SAP user at database level
Unlock SAP User

Note: Password reset is not possible using above method as the password is in encrypted format.

Related posts:

  1. Using SAP BRTOOLS Add Datafile To Oracle Database
  2. Login To Sybase ASE Database Using The iSQL
  3. How To Change SIDadm & SAPServiceSID Password On Windows Server
  4. RMAN – Check Oracle Database Consistency
  5. SAP Client Concept
  6. How To Set NLS_DATE_FORMAT Parameter In Oracle
  7. How To Terminate Database Session In MSSQL
  8. License keys for the SAP HANA Database
  9. ORACLE Central Inventory Is Corrupted
  10. 2EETW169 no connect possible: “DBMS = ORACLE— dbs_ora_tnsname
  • oracle unlock account
  • oracle unlock user
www.basisguru.comPrevious

RMAN – Check Oracle Database Consistency

www.basisguru.comNext

No Instance Profile Found Error while starting SAP

Recent Posts

  • CVE-2021-21465 Multiple vulnerabilities in SAP Business Warehouse (Database Interface)
  • SAP Security Updates For The Browser Control Google Chromium
  • SAP HANA Upgrade
  • LDAPRC 004 Error Maximum Number Of Find Results Exceeded
Quick Links
  • About Us
  • Contact Us
  • Privacy Policy
  • Disclaimer
Recent Posts
  • CVE-2021-21465 Multiple vulnerabilities in SAP Business Warehouse (Database Interface)
  • SAP Security Updates For The Browser Control Google Chromium
  • SAP HANA Upgrade
  • LDAPRC 004 Error Maximum Number Of Find Results Exceeded

Copyright © 2021 | WordPress Theme by MH Themes