Click here to Skip to main content
15,894,180 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Well I created this function to verify the password

SQL
<pre> CREATE OR REPLACE FUNCTION dd_pwd_fun(username varchar2, password varchar2)
   --Do stuff
   END dd_pwd_fun;


And I created it using the sysadmin account, when I'm trying to alter the profile and assign it this function, I'm having an error:

SQL
ALTER PROFILE prof_name LIMIT
    PASSWORD_VERIFY_FUNCTION dd_pwd_fun;
    ERROR at line 1: 
    ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION DD_PWD_FUN 


Why am I getting this? How can I add the function to the profile?
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900