A custom Oracle password-verification function, compiled successfully under SYS with no errors, can't be added to an Oracle Profile — the profile configuration reports the function can't be found, even though it clearly exists and compiled fine.

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Grant EXECUTE on the function to PUBLIC — for example, GRANT EXECUTE ON your_password_function TO PUBLIC — a custom password-verify function needs to be broadly executable (not just owned by SYS) for Oracle's profile-password-verification mechanism to actually be able to invoke it when attached to a database profile.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions