In the Oracle database, you can turn off password expiration for a specific user by altering the user's profile and setting the "password_life_time" attribute to "UNLIMITED." You can do this by using the following SQL command:
ALTER PROFILE profile_name LIMIT password_life_time UNLIMITED;
Where "profile_name" is the name of the user's profile. You can also use the following command to turn off password expiration for the user.
ALTER USER user_name PASSWORD EXPIRE;
Where "user_name" is the user's name for which you want to turn off password expiration. Please note that these commands must be executed by a user with appropriate privileges, such as a DBA or the user themselves if they have the ALTER USER privilege.
0 Komentar