一、查看用户状态: select username,acount_status from dba_users where account_status != 'OPEN';
二、给用户解锁: alter user userA ACCOUNT UNLOCK;
三、给用户重新设置密码:alter user userA IDENTIFIED BY password;
一、查看用户状态: select username,acount_status from dba_users where account_status != 'OPEN';
二、给用户解锁: alter user userA ACCOUNT UNLOCK;
三、给用户重新设置密码:alter user userA IDENTIFIED BY password;