Databases Reference
In-Depth Information
No authentication
There can be a requirement that NO authentication is necessary for the Oracle
Application Express application. This is named a public application; no login
page is shown, and all the pages of an application are accessible to all users.
Open door credentials
A built-in login page is displayed and you are prompted for a username. You can
enter any string, which then serves as the user identiier for the session.
Single sign on
In the
Single Sign On
(
SSO
) scheme, you must register the Oracle Application
Express site as a partner application with the Oracle Application Server - SSO server.
This method will be replaced in future releases with Oracle Access manager, because
SSO will be phased out in near future.
Oracle Cloud identity management
In Oracle Cloud identity management authentication you need to authenticate
against the Oracle Cloud identity management. This option will become available
in Oracle Application Express version 4.2 and higher.
Authorization
An authorization scheme speciies which data can be seen or not seen by users or
groups of users. Authorization may take place several times during the use of the
application. It determines the power of seeing or not seeing a particular data set, and
restricts access to speciic pages, components (for example forms, reports, or items),
or to a particular column in a report. Authorization is a process of determining
whether an authenticated or identiied person is permitted to access a resource or
do an operation. Authorizations are implemented by using authorization schemes.
If the component-level authorization succeeds, the user can view the component. If
the application-level or page-level authorization fails, Oracle Application Express
displays a predeined message. There are various types, such as Exists, SQL Query,
and PL/SQL functions.
An authorization scheme can be applied to any of the following:
• Application
• Page
• Component on a page (form or chart)
• Item, such as a button or a text ield
• Column in a report
