select username,expiry_date from dba_users;

SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE FROM DBA_USERS where username not like ‘SYS%’;

查询用户密码限制登录次数和密码过期天数：
select u.username,p.FAILED_NUM,p.life_time from SYSUSERS p,dba_users u where p.FAILED_NUM not in (‘0’) order by 1,2 ;
查询用户密码过期时间：
SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE FROM DBA_USERS where username not like ‘SYS%’;

select
username as “用户名” ,
password as “密码” ,
conn_idle_time as “用户会话的最大空闲时间” ,
life_time as “过期时间”,
lock_time as “锁定时间”,
FAILED_NUM as “失败登陆次数”
from sysusers a,all_users b
where id=b.user_id;