User Tools

Site Tools


tech:rdbms:ora_password_lifetime_unlimited

Set Oracle Profile PASSWORD_LIFE_TIME to "UNLIMITED"

The SQL below is for the DEFAULT profile.

Set PASSWORD_LIFE_TIME to UNLIMITED for Profile DEFAULT

alter profile DEFAULT limit PASSWORD_LIFE_TIME UNLIMITED;

See all properties for profile

select * from DBA_PROFILES where PROFILE = 'DEFAULT'
tech/rdbms/ora_password_lifetime_unlimited.txt · Last modified: 2024/02/21 19:09 by 127.0.0.1

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki