61. oracle给用户解锁

Posted on 2015-03-19 15:01  zkx4213  阅读(112)  评论(0编辑  收藏  举报

1.查看用户状态
select username,account_status from dba_users where username='test';

2.解锁:

ALTER USER YS_ADM ACCOUNT UNLOCK;

 

Copyright © 2024 zkx4213
Powered by .NET 8.0 on Kubernetes