Forgot your password?    
+ Reply to Thread
Results 1 to 4 of 4

Thread: how to unlock application user account

  1. #1

    how to unlock application user account

    User has locked account after attempting wrong password how we unlock user account without changing password

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    If Its a Database or an Applications User which includes APPS as well as the other Applications Database users like GL,AP (ORACLE users which have schemas on the Applications Database ) ,

    Connect to sqlplus as a DBA and issue :
    alter user <username> account unlock;

  3. #3
    thanx hemant

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Dev,

    If this is Application Account like "SYSADMIN", then the application account does not get locked, because they are only application account.

    The FND_USER table stores application user account passwords and the FND_ORACLE_USERID table stores internal Oracle Applications database account (i.e GL,PO etc)passwords. Both tables use the same encryption algorithm to protect the passwords.

    The FND_USER table contains all the application accounts. There are two password columns in this table: ENCRYPTED_FOUNDATION_PASSWORD and ENCRYPTED_USER_PASSWORD

    Check the ENCRYPTED_USER_PASSWORD and ENCRYPTED_FOUNDATION_PASSWORDS columns for the Application user, if the values of theses field is "INVALID", then you have only one option, just to reset the password for that user through System Admin responsibility(through application).
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. Lock and Unlock the User in Oracle 8i,9i, and 10g
    By Shahnawaz in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 06-19-2013, 08:05 PM
  2. Replies: 0
    Last Post: 01-10-2012, 06:22 PM
  3. Responsibility not visible to the user in list of responsibilities assigned to user
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-03-2011, 04:37 PM
  4. Count Current Forms Application Users Connected to the Application
    By Amit in forum SCRIPTS : Users,Profiles,Applications,Responsibilities,Forms,JDBC,Patch,Versions,Products
    Replies: 0
    Last Post: 11-01-2011, 03:25 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics