Custom Authentication and Authorization using ORACLE APEX

Custom Authentication and Authorization using ORACLE APEX
Authentication means confirming your own identity, whereas authorization means being allowed access to the system. In even more simpler terms authentication is the process of verifying oneself, while authorization is the process of verifying what you have access to.
FUNCTION user_aut (
p_username IN VARCHAR2, --User_Name
p_password IN VARCHAR2 -- Password
)
RETURN BOOLEAN
AS
lc_pwd_exit VARCHAR2 (1);
BEGIN
-- Validate whether the user exits or not
SELECT 'Y'
INTO lc_pwd_exit
FROM users
WHERE upper(LOG_IN) = UPPER (p_username) AND LOG_PAS = p_password and status='Y'
;
RETURN TRUE;
EXCEPTION
WHEN NO_DATA_FOUND
THEN
RETURN FALSE;
END user_aut;
[e-mail]
Like Comment Share Subscribe And Press The Bill Icon...
Facebook page: / oracle47

[@darrentan5098]

SELECT 'Y' INTO lc_pwd_exit May I know what does this two lines do? Does it set value 'Y' into lc_pwd_exit after fulfilling the WHERE CLAUSE? Because my table does not have status and still can't verify the username and password for the log in.

[@mohamedsameer3549]

Thanks, for this useful tutorial

[@masercot]

For future reference, it's "role". Enjoyed the video.

[@MegasXLR]

Uploaded on my birthday :)

[@NayagarhSensei]

Great job man , I was stuck at the custom authorisation now I will implement your ideas and try again. Can you make a tutorial of that item cart and printing methods

[@ahmad-easytech]

Whatsapp me

[@25muhdhafiz]

Hey I know it's a bit late but I tried this method and the validation is successful but after I apply changes and run the application, on the login page it says "Invalid Credentials". Is there any possible mistake that you can think about my application ?

[@ahmad-easytech]

may be you make some mistake

[@fip4070]

Great Job Sir.... Really Helpful ..

[@Nidheeshmtr]

How do you decide the order of parameters passed to custom authentication fn.? Is that by default first uname, then paswd?

[@ahmad-easytech]

for mor whatsaap m

[@kondayyadorababuvelisetti464]

Thanks alot

[@wajeehalwajeeh7247]

Thank you

[@matejaklobucar1194]

I want to create multiple users in Oracle APEX so when they log in they can see and edit only reports and data they have created while they were logged in with their username. Administrator can menage with all data of all users, but users only their own data. Do You have tutorial for this?

[@ahmad-easytech]

[phone] WHATSAAP ME

[@matejaklobucar1194]

@@ahmad-easytech do you have email or Facebook?

[@ahmad-easytech]

@@matejaklobucar1194 facebook.com/Oracle47 my page

[@davido8193]

how do you do this?

[@school8066]

Assalam Alaikum brother... How you added that report region could please make a video on adding a report region for classical reports printing with a form header...

[@ahmad-easytech]

Which Report ??

[@school8066]

@@ahmad-easytech printer friendly pdf report... My issue is I want to print invoice with header and details but all we get is rows and columns....

[@ahmad-easytech]

@@school8066 mail me [e-mail]

[@tempest13yearsago22]

Hello, u still active? I want to create log in form and connect it to website and everytime user log in or sign up, it stored data . Do you have tutorial?

[@ahmad-easytech]

yes you can by adding process

[@tempest13yearsago22]

@@ahmad-easytech thanks, but where i find it? I'm a senior high student here in Philippines and im exploring oracle database and recently we have a thesis project and we want to make a log in form that stores data and after logging in, it will direct to website that we create. Do you have Ig? I'll follow step by step how to connect log in to webpage and stores data You earned my sub👌

[@ahmad-easytech]

@@tempest13yearsago22 email me so i will help you

[@user-mr6px5ge7n]

thanks

[@sabrinaaisyah2174]

hi, in 10:06 i couldnt get the sql query, can you help me?

[@ahmad-easytech]

Whatsapp me or mail me.

[@SidraSiddiqui9913]

Very Nice explanation, is it possible to study the source code for this. Thank you very much

[@ahmad-easytech]

whatsapp me

[@ORACLEAPEX410]

can you tell me how to integrate ebs to apex

[@amitarya-iy1ok]

thankyou

[@heshammasoudme]

Hello great work Could you please help creating HR application using Apex depends on attending database

[@ahmad-easytech]

please mail what you want [e-mail] Whats app [phone]

[@Hussain54321]

Sir i am new in oracle Apex and want to learn Kindly provide source code.

[@roadtoallah9614]

Sir, Assalamualikum, i am from bangladesh and new in oracle apex, i do so as describe in this video then when i try to login an error show "ORA-06550: line 23, column 23: PLS-00201: identifier 'USER_AUT' must be declared", Sir plz help

[@ahmad-easytech]

whatsapp me [phone]

[@roadtoallah9614]

@@ahmad-easytech Sir can i get the code

[@ahmad-easytech]

@@roadtoallah9614 mail me or whats app

[@sabeelsiraturrehman4600]

Same Problem

[@Nidheeshmtr]

Is there any free reporting tools for apex?

[@ahmad-easytech]

yes too many oracle reports , jasper and many more

[@Nidheeshmtr]

@@ahmad-easytech oracle forms and reports? Which version?

[@jayakumar2927]

how to top menu with functionality forms can you share with me

[@ahmad-easytech]

didnt get you question what you want to say sir

[@abineshh8072]

sir can i get the code

[@ahmad-easytech]

mail me please

[@ahmad-easytech]

check your mail