Database Administration (MOSC)

MOSC Banner

How to set profile PASSWORD_VERIFY_FUNCTION limit to external function

edited Dec 25, 2013 9:13PM in Database Administration (MOSC) 7 commentsAnswered
Recently, I wanna to create a profile and set  PASSWORD_VERIFY_FUNCTION limit to function 'verify_function_general'  which I created in my own schema.
(Not under SYS,SYSTEM)  So far, I can't create it.

SQL> create PROFILE General_profile LIMIT
  2      PASSWORD_LIFE_TIME 65
    PASSWORD_GRACE_TIME 10
    PASSWORD_REUSE_TIME 300
    PASSWORD_REUSE_MAX 10
    FAILED_LOGIN_ATTEMPTS 5
    PASSWORD_LOCK_TIME 1/96
    PASSWORD_VERIFY_FUNCTION db_monitor.verify_function_general;  3    4    5    6    7    8 
    PASSWORD_VERIFY_FUNCTION db_monitor.verify_function_general
                                       *
ERROR at line 8:
ORA-02376: invalid or redundant resource

My question is how can profile refer to external function? Is that possible ?


Thanks
Jason

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