The first setup of an application is always a time consuming activity. To reduce that for all APEX developers I have create a template application with custom login functions.
The package includes all tables and functions you need to up and run you complete APEX application with a few clicks.
You can download the complete app
User the below code to get your own username en password
declare l_user_name varchar2(100); l_user_pwd varchar2(100); begin l_user_name :='firstname.lastname@example.org'; l_user_pwd := APP_SECURITY_PKG.get_hash('email@example.com','Welcome01'); UPDATE app_user SET usr_name = l_user_name, usr_pwd = l_user_pwd WHERE usr_id = 1; end;
Any question? drop a comment.