My situation:
1. I created a password verify function to check password complexity. The function is SYS.VERIFY_PASSWORD.
2. I created a profile PWD_TEST and set PASSWORD_VERIFY_FUNCTION to VERIFY_PASSWORD.
3. When I change a user's password (in that profile) from the DBA account, it uses the function fine.
4. When I try to change a password as the user, I get "ORA-28003: password verification for the specified password failed".
5. I have chopped the function down to a single RETURN TRUE; so it always passes... but no luck for the user.
I have tried granting execute on the function, adding a synonym, no luck. I can manually call the function as the user with no problem... but I cannot change my password as a user under that profile. Oracle docs only mention I may have to use LNOCIPasswordChange() but that is nuts; I need to make this work entirely in Oracle, not an external language. Any help here would be appreciated.
Thanks in advance,
Rich
____________________________
Rich Tefft
PL/SQL Programmer
1. I created a password verify function to check password complexity. The function is SYS.VERIFY_PASSWORD.
2. I created a profile PWD_TEST and set PASSWORD_VERIFY_FUNCTION to VERIFY_PASSWORD.
3. When I change a user's password (in that profile) from the DBA account, it uses the function fine.
4. When I try to change a password as the user, I get "ORA-28003: password verification for the specified password failed".
5. I have chopped the function down to a single RETURN TRUE; so it always passes... but no luck for the user.
I have tried granting execute on the function, adding a synonym, no luck. I can manually call the function as the user with no problem... but I cannot change my password as a user under that profile. Oracle docs only mention I may have to use LNOCIPasswordChange() but that is nuts; I need to make this work entirely in Oracle, not an external language. Any help here would be appreciated.
Thanks in advance,
Rich
____________________________
Rich Tefft
PL/SQL Programmer