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

This article mainly introduces the "PLsql login database prompt password is about to expire how to do", in the daily operation, I believe that many people in the PLsql login database prompt password is about to expire on the problem of doubt, Xiaobian consulted all kinds of information, sorted out a simple and easy-to-use method of operation, hope to answer the "PLsql login database prompt password is about to expire how to do" help! Next, please follow the editor to study!

-- first of all, you need a user with DBA permission to query:-- query the first step you have logged in.

SQL > select username,profile from dba_users where username='HR'

USERNAME PROFILE

HR DEFAULT

SQL > select username,profile from dba_users; to see other observations

Most of the discoveries are based on default profiles:

-- query default profile password retention time = = 180 days

Select * from dba_profiles where PROFILE='DEFAULT' and

RESOURCE_NAME='PASSWORD_LIFE_TIME'

DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

-- the password is valid for 180 days to be changed to unlimited:

Alter profile default limit password_life_time unlimited

A week later: PLSQL login error: limited to restricted user session permissions

CRT login, wrong report: ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege

-restricted mode, modified to normal mode

SQL > alter system disable restricted session

SQL > select USERNAME,ACCOUNT_STATUS,lock_date from dba_users; USERNAME ACCOUNT_STATUS LOCK_DATE

-

HR EXPIRED (GRACE)

SCOTT EXPIRED (GRACE)

OE EXPIRED & LOCKED 28-AUG-17

SQL > alter user hr account unlock;-invalid because this user is not locked, but expired

Alter user oe account unlock; LOCKED, use unlock

Alter user oe identified by oe; EXPIRED, use to change the password

SQL > alter user scott identified by tiger;-in the case of GRACE, password expiration is restricted, reset the password, or modify the profile indefinitely, so that the user will not expire.

-- the password is valid for 180 days to be changed to unlimited:

Alter profile default limit password_life_time unlimited

At this point, the study of "PLsql login database prompt password is about to expire" is over. I hope to be able to solve everyone's doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.