Open

How to login to application after assigning user using custom authentication in Oracle Apex

I'm new in oracle apex and I am seeking to make a custom authorization for the user login to the software. I have made a custom authentication for the log-in usage of this pl/sq. Code

FUNCTION user_aut    (

 p_username IN VARCHAR2, --User_Name

 p_password IN VARCHAR2 -- Password    

)

 RETURN BOOLEAN

AS

lc_pwd_exit VARCHAR2 (60);

BEGIN

 -- Validate whether the user exists or not

 SELECT 'Active'

 INTO lc_pwd_exit

 FROM USER_PROFILE

 WHERE upper("user_name") = UPPER (p_username) AND password = p_password and status='Active'

;

RETURN TRUE;

EXCEPTION

 WHEN NO_DATA_FOUND

 THEN

 RETURN FALSE;

END user_aut

However once I want to login the use of this i need to assign the consumer in "software get right of entry to manipulate". How to make the user can login with out manually assign the user to application access control? Or how to make custom authorization for the consumer to login to the software?