Image of How to reset password in Oracle 11g

ADVERTISEMENT

Introduction

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

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>’;

Summary

In order to reset a password in Oracle 11g:

Next Steps

If you're interested in learning more about the basics of Java, coding, and software development, check out our Coding Essentials Guidebook for Developers, where we cover the essential languages, concepts, and tools that you'll need to become a professional developer.

Thanks and happy coding! We hope you enjoyed this article. If you have any questions or comments, feel free to reach out to jacob@initialcommit.io.