查询用户的策略

select b.name,
a.CONN_IDLE_TIME as “空闲时间”,
a.PWD_POLICY as “口令策略”,
a.FAILED_NUM as “失败次数”,
a.life_time as “口令有效期”,
a.LOCK_TIME as “锁定时间”,
a.GRACE_TIME as “口令过期后宽限时间”,
a.LASTEST_LOCKED as “最近一次锁定时间”,
a.FAILED_ATTEMPS as “上次登录成功以来失败的登录次数”
from SYSUSERS a,SYS.SYSOBJECTS b where a.id=b.id;