Custom password verify function in PDB
Hi all,
I create a custom password verify function "ORA_CUST_VERIFY_FUNCTION" in sys schema on container DB and grant to public:
GRANT EXECUTE ON ora_cust_verify_function TO PUBLIC;
In the pluggable DB I want to associate the ora_cust_verify_function with the PASSWORD_VERIFY_FUNCTION of "DEFAULT" profile of pluggable, but i have the following error:
SQL> alter session set container=PDB1 ;
Session altered.
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION ORA_CUST_VERIFY_FUNCTION;
ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION ORA_CUST_VERIFY_FUNCTION
*
ERROR at line 1:
ORA-07443: function ORA_CUST_VERIFY_FUNCTION not found