Skip to main content
All CollectionsGeneralSecurity
Custom Password Verify Function
Custom Password Verify Function

Guide to the process of crafting a custom password verification function for your Oracle Database service managed by Tessell

Phoebe Farber avatar
Written by Phoebe Farber
Updated over 2 weeks ago

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;

/

Did this answer your question?