Skip to main content

Unlock/Reset the password for the users in Oracle

Let's say the user's password expired and locked it in Oracle. To unlock the users, use below commands.

  1. sqlplus "/as sysdba"
  2. alter user userName identified by password;
  3. alter user userName account unlock;

Comments

Popular posts from this blog

Get all constraints in Oracle

 To get all the constraints created in Oracle database, use below query.              SELECT * FROM USER_CONSTRAINTS; If you want to get the constraints  created for a particular user then use below SQL query.              SELECT   *   FROM  USER_CONSTRAINTS where owner = 'userName';