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?
0 Replies