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

This article mainly introduces the Oracle 11g user password default is 180 days expired how to modify, the article is very detailed, has a certain reference value, interested friends must read it!

In Oracle11g, in order to let the user change the database user password within half a year, the default password of the database user is valid for 180 days by default, while the default password of the database user in Oracle10g is indefinite.

View the password parameter file used by the default database user of Oracle11g

SQL > SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'

PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT

-

DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

Change the password to indefinite

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

The above is "Oracle 11g user password default is 180 days expired how to change" all the content of this article, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.