Oracle input error count modification, user unlock, password expiration

Source: Internet
Author: User

Oracle input error count modification, user unlock, password expiration

By default, Oracle databases lock users after 10 failed attempts;

1. view the FAILED_LOGIN_ATTEMPTS Value

Select * from dba_profiles;

2. Change it to 30 alter profile default limit FAILED_LOGIN_ATTEMPTS 30;

3. Change it to an unlimited number of times (not recommended for security reasons) alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;

User unlock:

Alter user user_name account unlock;

Oracle Password Expiration settings:

The default password expiration limit for Oracle 11G users is 180 days. If the user password is not modified for more than 180 days, the user cannot log on.

Available

SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

Statement to query the password's validity period settings. The LIMIT field is the password's validity period.

When the password is about to expire or has expired, you can use:

Alter user Username identified by password;

Statement to modify the password. After the password is changed, the user can connect to the database normally.

Long-term correspondence can be achieved through:

Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED

Statement to change the password validity period from 180 days to "unlimited ".

For database security considerations, it is not recommended to set the PASSWORD_LIFE_TIME value to UNLIMITED. We recommend that you modify the database user password periodically.

Oracle 11g password expired locked reporting ORA-28000 the account is locked

Solution to Oracle user password expiration and user lock

Password expired ORA-28002 troubleshooting

ORA-28002 Password Expiration Warning

The ORA-28002 password will expire in 7 days

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.