How to Create Dynamic User in Oracle Application | Oracle APEX

#oracleapex #dynamicuser #oracleapexbangladesh

[@parthparth8680]

VALUABLE DEMO for User Creation in Oracle Apex...Really Useful for Apex Developer

[@sklinfo5489]

ZazakAllah khairan

[@alexeuzebio2405]

Thanks for the demo

[@xranitel13]

FINALLY I FIND IT

[@ashokkhairnar6180]

This is good and I created same as per video, but not working and error showing - line 4, column 23: "PLS-00306: wrong number or types of arguments in call to 'AUTH'. PL/SQL: Statement ignored at login page. Please help on this and I used strong password validation on password.

[@hemukarnik]

hi can i have a script for this video

[@danandreionofrei3419]

When you are creating the trigger you are using a function named CUSTOM_HASH, that you are not presenting in this video. Can you show us the CUSTOM_HASH function?

[@danandreionofrei3419]

CUSTOM_HASH function from trigger is "encrypted" function from 0:50. Thank you!

[@rodasluis1308]

CREATE OR REPLACE FUNCTION HASH_PASSWORD (p_user_name in varchar2, p_password in varchar2) return varchar2 is l_password varchar2(255); -- The following salt is an example. -- Should probably be changed to another random string. l_salt varchar2(255) := '2345USFGOJN2T3HW89EFGOBN23R5SDFGAKL'; begin -- -- The following encryptes the password using a salt string and the -- DBMS_OBFUSCATION_TOOLKIT. -- This is a one-way encryption using MD5 -- l_password := utl_raw.cast_to_raw ( dbms_obfuscation_toolkit.md5( input_string => p_password || substr(l_salt,4,14) || p_user_name || substr(l_salt,5,10))); return l_password; end hash_password; /