Sunday , March 3 2024

How To Change User Password In Oracle Database

In today’s article, we will be cover about How to Change User Password in Oracle Database.

The person who will change the password must have “ALTER USER” system authority.

The password is case sensitive.

SQL SENTENCES

1. From SQL*PLUS:

2. FROM TERMINAL or TOAD:

In addition, a user who forgot his password can reset his password and create a new password for himself.

In this case we use the following command.

What we need to pay attention to is that at least 5-6 characters of the password are not the same as the old password.

Loading

About Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories