修改Oracle默認密碼過期天數(shù)

    解決方法：
    1.查看用戶用的哪種profile策略
    SQL> select username,profile from dba_users;
    USERNAME PROFILE
    ------------------ -----------------
    MGMT_VIEW DEFAULT
    SYS DEFAULT
    SYSTEM DEFAULT
    EKPUSER DEFAULT
    2.查看策略的有效天數(shù)
    SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
    PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
    ------------------------------ ----------------------- ------------ --------
    DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
    3.修改策略為無限制
    SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
    Profile altered
    4.查看確認
    SQL> Select * FROM dba_profiles s Where s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
    PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
    ------------------------------ -------------------- ------------- ----------
    DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
    修改為及時生效，無需重啟數(shù)據(jù)庫