select username,account_status,AUTHENTICATION_TYPE,ORACLE_MAINTAINED from dba_users order by 3,2,1
USERNAME ACCOUNT_STATUS AUTHENTICATION_T OR
------------------------------ -------------------- ---------------- --
APPQOSSYS LOCKED NONE Y
AUDSYS LOCKED NONE Y
DBSFWUSER LOCKED NONE Y
DBSNMP LOCKED NONE Y
DIP LOCKED NONE Y
DVF LOCKED NONE Y
DVSYS LOCKED NONE Y
GGSYS LOCKED NONE Y
GSMADMIN_INTERNAL LOCKED NONE Y
GSMCATUSER LOCKED NONE Y
GSMROOTUSER LOCKED NONE Y
GSMUSER LOCKED NONE Y
LBACSYS LOCKED NONE Y
MDDATA LOCKED NONE Y
MDSYS LOCKED NONE Y
OJVMSYS LOCKED NONE Y
OLAPSYS LOCKED NONE Y
ORACLE_OCM LOCKED NONE Y
ORDDATA LOCKED NONE Y
ORDPLUGINS LOCKED NONE Y
ORDSYS LOCKED NONE Y
OUTLN LOCKED NONE Y
REMOTE_SCHEDULER_AGENT LOCKED NONE Y
SI_INFORMTN_SCHEMA LOCKED NONE Y
SYS$UMF LOCKED NONE Y
SYSBACKUP LOCKED NONE Y
SYSDG LOCKED NONE Y
SYSKM LOCKED NONE Y
SYSRAC LOCKED NONE Y
WMSYS LOCKED NONE Y
XDB LOCKED NONE Y
ANONYMOUS EXPIRED & LOCKED PASSWORD Y
CTXSYS EXPIRED & LOCKED PASSWORD Y
XS$NULL EXPIRED & LOCKED PASSWORD Y
HR OPEN PASSWORD N
SYS OPEN PASSWORD Y
SYSTEM OPEN PASSWORD Y
AUTHENTICATION 和 NO AUTHENTICATION之间的转换
通过如下命令可以很容易的在Schema Only Account和Normal Account之间转换：
ALTER USER ... IDENTIFIED BY ...;
ALTER USER ... NO AUTHENTICATION;
SQL> alter user hr no authentication;
用户已更改。
SQL> select username,account_status,AUTHENTICATION_TYPE,ORACLE_MAINTAINED from dba_users where username='HR' order by 3,2,1;
USERNAME ACCOUNT_STATUS AUTHENTICATION_T OR
------------------------------ -------------------- ---------------- --
HR OPEN NONE N
SQL>
之后，你随便登录多少次，都不能登录，不存在爆破口令的问题。
要让他登录了，修改口令即可。
SQL> alter user hr identified by hr;
用户已更改。
SQL> select username,account_status,AUTHENTICATION_TYPE,ORACLE_MAINTAINED from dba_users where username='HR' order by 3,2,1;
USERNAME ACCOUNT_STATUS AUTHENTICATION_T OR
------------------------------ -------------------- ---------------- --
HR OPEN PASSWORD N
SQL>