password_verify_function Profile Parameter Shows LIMIT as "FROM ROOT" When Connected to non PDB database (Doc ID 2988953.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

- This is NOT a multi-tenant environment.

- password_verify_function Profile Parameter Shows LIMIT as "FROM ROOT" When Connected to non PDB database
   
STEPS
-----------------------
1. Changed PASSWORD_VERIFY_FUNCTION to ORA12C_VERIFY_FUNCTION :

    SQL> alter profile GSM_PROF limit password_verify_function ORA12C_VERIFY_FUNCTION;
 
2. Displayed password_verify_Function as FROM ROOT.

select * from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';

PROFILE               RESOURCE_NAME                       RESOURCE       LIMIT                                     COM INH IMP
--------------------  ------------------------------         --------            -----------------------------------  --- --- ---
DEFAULT               PASSWORD_VERIFY_FUNCTION    PASSWORD      VERIFY_FUNCTION                    NO NO NO
GSM_PROF            PASSWORD_VERIFY_FUNCTION    PASSWORD      FROM ROOT                            YES YES NO --->> !!

Changes

Changed the profile limit.

Cause

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