Shulou(Shulou.com)05/31 Report--

This article focuses on "how to use oracle to modify password expiration problem", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to use oracle to modify the password expiration problem.

Program error report

Java.sql.SQLException: ORA-28001: the password has expired

A description of ORA-28001.

28001, 00000, "the password has expired"

/ / * Cause: The user's account has expired and the password needs to be

/ / changed

/ / * Action: change the password or contact the DBA

/ /

Change the user's password first.

Alter user USER identified by USER

After communication, it is necessary to cancel the password expiration policy and modify it to use it without expiration.

Check the proifle to which the user belongs (default is default):

SELECT username,PROFILE FROM dba_users where username='USER'

USERNAME PROFILE

USER DEFAULT

Check the password policy of profile now

SELECT * FROM dba_profiles 's WHERE s.profileholders defaULT 'AND resource_name='PASSWORD_LIFE_TIME'

PROFILE RESOURCE_NAME RESOURCE LIMIT

-

DEFAULT PASSWORD_LIFE_TIME PASSWORD 90

Change the password validity of profile from 90 days to "unlimited":

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

After the modification, there is no need to restart the database, it will take effect immediately.

The oracle11g startup parameter resource_limit, whether false or true, the password policy is in effect.

At this point, I believe you have a deeper understanding of "how to use oracle to modify password expiration". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.