Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Custom Authentication - With open door credentials

guruparanNov 25 2008 — edited Nov 25 2008
Hi All

I was previously using APEX Authentication, managing Apex users and restricting them turned out to be a head ache. Now I need a design a login page based on a password table stored in a schema (workspace). Simillar the demo applications installed in Apex already.

SQL> desc CM_SYS_USERS
Name Null? Type
--------------------------------------- -------- ------------
USER_NAME N VARCHAR2(30)
PASSWORD VARCHAR2(50)
PASSWORD_EXPIRED VARCHAR2(1)
LAST_LOGIN DATE

My idea is to -
1. Show in-built login page.
2. Get username and password
3. Check CM_SYS_USERS for password/username verification
4. Proceed to HOME page.

I am finding it difficult for reference. Please let me know the links if you have.

Thanks a lot
This post has been answered by John Edward Scott on Nov 25 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2008
Added on Nov 25 2008
#apex, #apex-discussions, #authentication, #custom
2 comments
835 views