Started by Jhone ButtlerNov 6, 2021

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

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

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

You must be Logged in to reply
Trending Categories
15
Software39
DevOps45
Frontend Development24
Backend Development20
Server Administration17
Linux Administration24
Data Center24
Sentry24
Terraform21
Ansible29
Docker28
Penetration Testing14
Kubernetes16
NGINX19
JenkinsX17
Techiio

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

facebooklinkdeintwitter

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Copyright techiio.com @2020 Kolkata, India
made with by Abhishek & Priyanka Jalan
Copyright techiio.com @2020
made with by Abhishek & Priyanka Jalan