Introduction
This document serves as a comprehensive guide, offering detailed insights into the process of crafting a custom password verification function for your Oracle Database service managed by Tessell
Step-by-Step Guide
You can create a custom verification logic and avoid storing your function in the SYS schema by using the procedure tesselladmin.database_password_policy.create_passthrough_function. This procedure creates a wrapper function in SYS Schema for your password custom verification function.
The create_passthrough_function procedure has the following parameters:
Parameter name
| Description
|
p_function_name | The name for your custom verification function. This is a wrapper function that is created for you in the SYS schema, and it doesn't contain any verification logic. You assign this function to user profiles. |
p_target_schema | The schema owner for your custom verification function. |
p_target_function_name
| The name of your existing custom function that contains the verification logic. Your custom function must return a boolean. Your function should return true if the password is valid and false if the password is invalid. |
All parameters are required and have Varchar2 as Data Type
BEGIN
tesselladmin.database_password_policy.create_passthrough_function(
p_function_name => 'CUSTOM_PASSWORD_FUNCTION_IN_SYS',
p_target_schema => 'MASTER',
p_target_function_name => 'CUSTOM_PASSWORD_LOGIC_FUNCTION_IN_MASTER');
END;
/