查看用户状态(是否被锁)
select * from dba_users where username=‘user1’
– 解锁 user1表示实例名
ALTER USER user1 ACCOUNT UNLOCK;
– 修改用户密码 user1表示实例名
alter user user1 identified by newpass;
查看用户状态(是否被锁)
select * from dba_users where username=‘user1’
– 解锁 user1表示实例名
ALTER USER user1 ACCOUNT UNLOCK;
– 修改用户密码 user1表示实例名
alter user user1 identified by newpass;