Oracle Apex - Authorization

Card Puncher Data Processing

About

While conditions control the rendering and processing of specific controls or components on a page, authorization schemes control user access.

Authorization schemes use the identities established by authentication to grant privileges on applications and objects within them.

You can specify an authorization scheme for:

Example

  • Selectively determine which tabs, regions, or navigation bar entries a user sees.

Management

Entire Application

Application > Edit Application Properties > Security

Oracle Apex Authorization Application

API

You can use the APEX_UTIL package to check authorizations for users

Metadata

Scheme

Authorization Scheme metadata for a page

SELECT   pages.id
  , pages.name
    || ' ('
    || pages.id
    || ')' AS "Page"
  , CASE
      WHEN scheme.name IS NOT NULL
      THEN scheme.name
        || ' ('
        || pages.required_role
        || ')'
    END AS "Authorization Scheme"
  FROM WWV_FLOW_STEPS pages
  , WWV_FLOW_SECURITY_SCHEMES scheme
  WHERE pages.flow_id     = 109
  AND pages.required_role = scheme.id (+)
  ORDER BY pages.id

Documentation / Reference





Discover More
Oracle Apex Report Columns Metadata
Oracle Apex - Metadata

The metadata of Oracle Apex are stored in a schema prefixed with APEX. From this schema, you can query the whole application definition: from page to columns APEX_APPLICATION_ALL_AUTH APEX_APPLICATION_AUTH...



Share this page:
Follow us:
Task Runner