Database Security Products (MOSC)

MOSC Banner

Custom password verify function in PDB

edited Oct 25, 2019 1:22AM in Database Security Products (MOSC) 2 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center