察看用户状态(是否被锁)
select * from dba_users where username='user1'
解锁
ALTER USER user1 ACCOUNT UNLOCK;
修改用户密码
alter user user1 identified by newpass;
察看用户状态(是否被锁)
select * from dba_users where username='user1'
解锁
ALTER USER user1 ACCOUNT UNLOCK;
修改用户密码
alter user user1 identified by newpass;