设置时间格式:
SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
查询用户什么时候被锁定:
SQL> select username,account_status,lock_date from dba_users where username='JTOMSWAS';
USERNAME ACCOUNT_STATUS LOCK_DATE
-------- -------------------------------- -------------------
JTOMSWAS LOCKED(TIMED) 2008-12-09 14:38:31
用超级用户解锁用户:
SQL> alter user jtomswas account unlock;
User altered.
看看上面这个设置登陆失败几次即锁定帐户的参数是多少:
SQL> select * from dba_profiles where resource_name='FAILED_LOGIN_ATTEMPTS';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD
10
尝试登陆10次失败后,被锁定账号