My Oracle Support Banner

Query about changing the PASSWORD_VERIFY_FUNCTION in a given profile (Doc ID 2881592.1)

Last updated on JULY 26, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

Currently, the profile that we want to change has a null value in the PASSWORD_VERIFY_FUNCTION
it would be changed to a function with restrictions on the minimum size of the password length and its complexity.

What would happen to those users who already belong to that profile, considering that they continue to have that profile and that it is not necessary to change the password of those users.
Could they log in with the same username and password to the database instance and would it not affect any attribute that username and password have?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.