select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'; ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;