Oracle系列---【查看用户状态与修改密码】

1.查看被锁住的用户

SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE ACCOUNT_STATUS LIKE '%LOCKED%';

2.修改指定用户名密码

sqlplus / as sysdba;
GRANT DBA TO your_username;
sqlplus username/password as sysdba;


-- 只修改密码为新密码
ALTER USER AFP_COM_ASC IDENTIFIED BY AFP_COM_2001;
-- 建议修改为原密码，不然很多应用都需要重新改密码
ALTER USER AFP_COM_ASC IDENTIFIED BY AFP_COM_2000;


-- 修改密码为新密码并解锁(用户被锁的时候用这个)
ALTER USER AFP_COM_ASC IDENTIFIED BY AFP_COM_2001 ACCOUNT UNLOCK;
-- 建议修改为原密码，不然很多应用都需要重新改密码,容易锁住
ALTER USER AFP_COM_ASC IDENTIFIED BY AFP_COM_2000 ACCOUNT UNLOCK;

3.解锁指定用户名

ALTER USER AFP_COM_ASC ACCOUNT UNLOCK;