PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
------------------------------ -------------------------------------------------- ---------------- --------------------------------------------------------------------------------
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1 ---关注,表明连续多次失败登陆后,账户锁定的天数,默认为1天
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 --关注 ,指定多少天,即如果你在指定天数之内不改密码就会提示密码失败无法登陆
关注上述参数的含义,请见:
Oracle? Database SQL Language Reference
11g Release 2 (11.2)
Part Number E26088-03
之
create profile
可见expiry_date即账期何时会过期,此列一直有数据,只要用户创建
SQL> select username,password,account_status,expiry_date,lock_date,profile from dba_users;