Manage user passwords and unlock users using Profile

Profile management user password and unlock user use profile Management user Password account lock 1) Lock SQL> create profile lock_account limitfailed_login_attempts 3 password_lock_time 1; ---- create a profile named lock_account, three logon failures, the user is locked. The lock time is one day. SQL> alter user xiaoming profile lock_account; www.2cto.com ---- grant the profile file to a user. 2) unlock SQL> alter user xiaoming account unlock; 3) terminate password Delete profile SQL> drop profile password_history cascade; note: the main function of profile is to control user resources and passwords. Code is very important to system security. Unlock and kill the lock table process 1. view the lock www.2cto.com select t2.username, t2.sid, t2.serial #, t2.logon _ time from v $ locked_object t1, v $ session t2 where t1.session _ id = t2.sid; 2. Kill -- alter system kill session 'sid, serial #';
Alter system kill session '2017 78 ';