Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieve page information from APEX dictionary for authorisation purposes

van Baal HRNov 14 2017 — edited Nov 14 2017

Hello Everyone!

I want to query the APEX data dictionary for the pages I have created. The authorisation concept here dictates, that the pages created with APEX, must be granteable to roles and therefore I need to query the dictionary. Unfortunately I do not know what tables to access. Some stay empty, even when I connect to the database as DBA

Does anybody have a tip, what I can do here?

Thank you very much

Hans

***Moderator action (TImo): removed signature link as it is considered as spam!***

This post has been answered by fac586 on Nov 14 2017
Jump to Answer

Comments

fac586
Answer 
van Baal HR wrote:
I want to query the APEX data dictionary for the pages I have created. The authorisation concept here dictates, that the pages created with APEX, must be granteable to roles and therefore I need to query the dictionary. Unfortunately I do not know what tables to access. Some stay empty, even when I connect to the database as DBA 
Does anybody have a tip, what I can do here?

Many of the APEX views contain restrictions based on the database user being the parsing schema for the application, or a schema associated for the workspace. Some are dependent on being queried from an active APEX session.

The views can be interactively explored using the APEX Views utility in the Application Builder, and the dictionary is extensively documented in the APEX_DICTIONARY metadata view:

select * from apex_dictionary where apex_view_name = '<view name>'

Marked as Answer by van Baal HR · Sep 27 2020
van Baal HR

The query, that gave me the wanted information is:

SELECT *

  FROM apex_application_pages

WHERE application_id = 103

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 12 2017
Added on Nov 14 2017
#apex, #apex-discussions
2 comments
436 views