取消密码过期oracle,取消ORACLE11g用户密码过期

sqlplus / as sysdba

set linesize 120

set pagesize 1000

select * from dba_profiles where profile='DEFAULT' and RESOURCE_TYPE='PASSWORD';

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD 10

DEFAULT                        PASSWORD_LIFE_TIME               PASSWORD 180

DEFAULT                        PASSWORD_REUSE_TIME              PASSWORD UNLIMITED

DEFAULT                        PASSWORD_REUSE_MAX               PASSWORD UNLIMITED

DEFAULT                        PASSWORD_VERIFY_FUNCTION         PASSWORD NULL

DEFAULT                        PASSWORD_LOCK_TIME               PASSWORD 1

DEFAULT                        PASSWORD_GRACE_TIME              PASSWORD 7

alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

alter profile default limit PASSWORD_GRACE_TIME UNLIMITED;

阅读(576) | 评论(0) | 转发(0) |