The PASSWORD_VERIFY_FUNCTION value specifies a PL/SQL function to be used for password verification when users assigned this profile log in to a database.
This function may be used to validate the strength of passwords by requiring them to pass a PL/SQL strength test.
On the database to which this profile applies, the function must be locally accessible for execution.
Oracle offers a default script (utlpwdmg.sql) that you may use as a starting point for creating your own function. This profile parameter's default value is NULL, which means no password verification is done.
To Verify
From SQL*Plus:select profile, limitfrom dba_profiles,(select limit as def_pwd_verify_funcfrom dba_profileswhere resource_name='PASSWORD_VERIFY_FUNCTION'and profile='DEFAULT')where resource_name='PASSWORD_VERIFY_FUNCTION'and replace(limit, 'DEFAULT', def_pwd_verify_func) in('UNLIMITED', NULL);
To Create New Password_Verify Function in Oracle Database 19c
The PASSWORD_VERIFY_FUNCTION value specifies a PL/SQL function to be used for password verification when users assigned this profile log in to a database.
This function may be used to validate the strength of passwords by requiring them to pass a PL/SQL strength test.
On the database to which this profile applies, the function must be locally accessible for execution.
Oracle offers a default script (utlpwdmg.sql) that you may use as a starting point for creating your own function. This profile parameter's default value is NULL, which means no password verification is done.
To Verify
From SQL*Plus: select profile, limit from dba_profiles, (select limit as def_pwd_verify_func from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION' and profile='DEFAULT') where resource_name='PASSWORD_VERIFY_FUNCTION' and replace(limit, 'DEFAULT', def_pwd_verify_func) in ('UNLIMITED', NULL);
To Create New Password_Verify Function in Oracle Database 19c
view the link mentioned below: