Shulou(Shulou.com)06/01 Report--

Step 1: use an administrator account or log in with dba privileges, such as a system account

Step2: execute SELECT * FROM DBA_USERS where username like'% TEST%'

Where account_status is the status.

States can be divided into two categories: 1. Basic state; 2. Combination status.

Basic state: 0 OPEN, 1 EXPIRED, 2 EXPIRED (GRACE), 4 LOCKED (TIMED), 8 LOCKED

The last four are basic states: 5 EXPIRED & LOCKED (TIMED), 6 EXPIRED (GRACE) & LOCKED (TIMED), 9 EXPIRED & LOCKED, 10 EXPIRED (GRACE) & LOCKED

1. The OPEN status indicates that the user is in a normal state.

2. LOCKED and LOCKED (TIMED) indicate that the user is locked out.

There are two types of users locked out:

One is that DBA explicitly locks the user through SQL statements.

The other is passive locking, if the password is entered incorrectly more than 10 times by default.

This restriction is controlled by FAILED_LOGIN_ATTEMPTS in PROFILE, and you can view the view DBA_PROFILES.

1) explicitly lock user LOCKED:alter user [username] account lock

2) passively lock LOCKED (TIMED) after entering 10 incorrect passwords

3) EXPIRED and EXPIRED (GRACE) indicate that the user password expires.

You can use select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'

Check first

Modify whether the PASSWORD_LIFE_TIME implementation password in PROFILE expires: alter profile default limit password_life_time unlimited

The number of days used by the PASSWORD_GRACE_TIME control in PROFILE can also be modified after the password expires: alter profile default limit password_grece_time 180

4) for users with expired passwords, OPEN:alter user [username] identified by account unlock

If you execute alter user TEST08 identified by password, it means to change the password of the expired test08 account to password.

5) if the account is locked, you need to unlock the command

Alter user XXXUSER identified by oracle account unlock

Or ALTER USER xxuser ACCOUNT UNLOCK directly.

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.