Can a new user create an account (username/password) using Oracle Apex

Posted on 2011-05-02
Last Modified: 2012-05-11
I was wondering if apex can be used in a way where new users can create their own user accounts.  I'm new to apex and want to experiment how it can be used.  I would like to make an E-Harmony type of website where people can create accounts and input personal information and then have users find people who have similar interests.  Is this possible using Apex?
Question by:dmalovich
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    The UI really doesn't matter here.  You don't create database users.  You create a table in the app that stores the users/passwords (hashsed).  Then the UI takes the information entered and validates it against that table.

    Not used APEX but I would expect it to do this rather easily.
    LVL 40

    Expert Comment

    slightwv is right, these aren't DB users.

    List tables that belong to APEX, login as the apex user (flows_xxx or apex_xxx) depending. (select username from dba_users to find out)
    LVL 73

    Expert Comment

    easiest way within the context of APEX would probably be to create an authentication and authorization scheme and apply it to every page except the home page and those associated with the creation of a user.

    You "could" have database accounts, but as noted in previous posts, it wouldn't be recommended.  Use application accounts.

    You could  also do it with 2 apps,  one that does not require authentication and allows creation of new users, the other that requires authentication.

    To the end user,  it's just a series of web pages so  one app vs two is up to you and whatever will be easiest to maintain

    Author Comment

    So the administrator would have nothing to do with new users coming to the site and creating there own username/password?  Is this stored in the database?
    LVL 76

    Accepted Solution

    Yes.  That is how it 'should' be.

    The application logs into the database.  Users log into the app.

    At a simplest form:  Create a 'users' table with id and password.  When the user provides login credentials, the app selects from the table to see if everything matches.

    Again: HASH the password in the app, store and query the hashed version and store that.  This way the password is never in clear text.

    Author Closing Comment

    Awesome Thanks....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now