[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2011-05-02
Medium Priority
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 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35505930
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

ID: 35505989
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 74

Expert Comment

ID: 35506064
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 35506173
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 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 35506205
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

ID: 35506257
Awesome Thanks....

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

834 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