How to reset password in Oracle 11g

1. Reset password

In order to reset a password in Oracle 11g:

  • Log in as a system user through sqlplus or any oracle client.
  • Run this command: alter user <user_name> identified by <password>

2. Turn off password expiration

In order to turn off the password expiration for a particular user, do the following:

  • First of all, check which profile the user is using by running this command:

select profile from DBA_USERS where username = ‘<user_name>’

  • Then, change the limit to never expire using:

alter profile <profile_name> limit password_life_time UNLIMITED;

  • You can always check the password limit of your user using:

select resource_name,limit from dba_profiles where profile='<profile_name>’;

Hussein Terek

Founder of programmergate.com, I have a passion in software engineering and everything related to java environment.

You may also like...

Leave a Reply

avatar