查询用户
select username,account_status,lock_date from dba_users;
1.解锁用户
ALTER USER 账户名 ACCOUNT UNLOCK;
2.查询密码
select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';
3. 修改为30次
select * from dba_profiles ;
查询用户
select username,account_status,lock_date from dba_users;
1.解锁用户
ALTER USER 账户名 ACCOUNT UNLOCK;
2.查询密码
select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%';
3. 修改为30次
select * from dba_profiles ;