Skip to main content

Command Palette

Search for a command to run...

Lists and Authorization Scheme in Oracle Apex.

Doing it wrong?

Updated
1 min read
Lists and Authorization Scheme in Oracle Apex.
T

Databaseguy, Oracle Apex Lover

I learned a lot about APEX_DICTONARY Views.. and a found a couriosity:

You can do this:

APPONE:
Navigation Menu

2 Entries...

Define on "Statistics" Entry is a Second List:

This List is defined here:

Thats all fine.. Yes it can be ok, that Master-Menu Entries has the same name as in der Sublist/menu..

If we Query APEX_APPLICATION_ALL_AUTH we got DUPLICATES:

In our Development Team we defined a Function for Authorization Scheme usage.

We got on each List entry the identical Parameters (of course)

APP_ID=100
APP_PAGE_ID NULL
APP_NAME = APPONE
APP_COMPONENT_TYPE = APEX_APPLICATION_LIST_ENTRIES
COMPONENT_NAME = Statistics

Conclusio: We should not use duplicate Listnames! the handle Privileges for Lists correctly in our Function.

Because we can share Lists over more multiple Applications we should be aware of this tooo..

T

https://apexblog.dev/apex-dictionary-views-you-didnt-know-you-needed

APEX Implemented Correctly? YES/NO?

Part 20 of 28

The series is a exploration of Oracle APEX settings and configurations, focusing on ensuring they are optimized and aligned with best practices.

Up next

Dynamic Actions in Interactive Grid

Doing it wrong? (TL:DR Yes)