Oracle数据库用户的密码过期时间如何修改为永不过期

SELECT * FROMdba_profiles s WHERE s.profile= 'DEFAULT' ANDresource_name= 'PASSWORD_LIFE_TIME' ;

SELECT * FROMdba_profiles s ;

--查看用户profile

select username, user_id, account_status,expiry_date, profile from dba_users where username = 'MESSERIES' ;

--1. 创建新的profile（PASSWD_UNLIMIT）复制DEFAULT的Script

CREATE PROFILE "PASSWD_UNLIMIT" LIMIT

  SESSIONS_PER_USER UNLIMITED

  CPU_PER_SESSION UNLIMITED

  CPU_PER_CALL UNLIMITED

  CONNECT_TIME UNLIMITED

  IDLE_TIME UNLIMITED

  LOGICAL_READS_PER_SESSION UNLIMITED

  LOGICAL_READS_PER_CALL UNLIMITED

  COMPOSITE_LIMIT UNLIMITED

  PRIVATE_SGA UNLIMITED

  FAILED_LOGIN_ATTEMPTS 10

  PASSWORD_LIFE_TIME 180

  PASSWORD_REUSE_TIME UNLIMITED

  PASSWORD_REUSE_MAX UNLIMITED

  PASSWORD_LOCK_TIME 1

  PASSWORD_GRACE_TIME 7

  PASSWORD_VERIFY_FUNCTION NULL ;

SELECT * FROMdba_profiles;

--2. 修改新建的profile（PASSWD_UNLIMIT），密码过期为不过期

ALTER profilePASSWD_UNLIMIT limit PASSWORD_LIFE_TIME UNLIMITED;

--3. 修改用户的Profile为新的profile

alter user MESSERIES profile PASSWD_UNLIMIT;