How to make an Application Express application public.

How-To Document

Make an Oracle Application Express (formerly HTML DB) Application Public

Date: 1-Nov-2003
Based on Application Express version 2.0

After completing this How-To, you should be able to understand:

The steps involved in changing the Authentication Scheme in an HTML DB Application in order to make it public

Introduction

Many HTML DB applications do not need to require a user to authenticate. This How-To will explain how to make an HTML DB application public and not prompt users for a username and password.

Software Requirements

Oracle HTML DB
The Database Access Descriptor (DAD) used to run HTML DB should be configured to store the username and password

Steps Required

Log into HTML DB
Click on Application Builder
Click on the icon for the Application that you wish to make public.
Click on the Shared Components icon.
Click the Authentication Schemes link.
If there is a scheme called DATABASE, click on the Change Current link
Select the DATABASE authentication scheme in the Available Authentication Schemes field and click Next >.
Click the Make Current button

At this point, your application is now public. If you did not have an authentication scheme called DATABASE, then you must complete the steps below to create one:

Log into HTML DB
Click on Application Builder
Click on the icon for the Application that you wish to make public.
Click on the Shared Components icon.
Click the Authentication Schemes link.
Click the Create button.
Click the Authentication Schemes link.
Click the Authentication Schemes link.
Select Based on a pre-configured scheme from the gallery and click on Next >
Select No Authentication (using DAD) and click on Next >
Give the scheme any name you would like to - ex: DATABASE and then click on Create Scheme
Click the Change Current link
Select the DATABASE authentication scheme in the Available Authentication Schemes field and click Next >.
Click on the Make Current button.