APEX

Hello!

I'm trying to find out how to make an authorization scheme for database users.

I first made an authentication scheme for my current application, I named it "Authentication for database accounts", and the scheme type is "Database Accounts".

A word of explanation:_
I have a table in my database, named "USERS". Inside this table, I have the following columns:
- USERID (NUMBER)
- USERNAME (VARCHAR2(50))
- PASSWORD (VARCHAR2(50))
- EMAIL (VARCHAR2(200))

For this question, I'll take an example user. The username is USER and the password is USER. Email and UserID don't matter here, but let's just say the UserID is 1.

What I want:_
When you go to the application, and you are requested to log in (page 101), then I want a user to be able to log in with the data that has been stored in the USERS table.
So, on the login page, the user will enter USER as username, and USER as password. The authorization scheme then needs to check whether or not this username and password match the data in the USERS table. If it does, then it must sign the user in with the credentials the user entered (those being USER and USER).
I also want the UserID to be stored somewhere in the application (if possible, in an application item).

How do I do this? I've never made an authorization scheme before... I'm not too good with PL/SQL either, but I'm working on that part.

Any help is greatly appreciated.