Skip to Main Content
Forums

Security Software

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!

AD > OUD DIP Sync Status Info

nick.huntJun 12 2014 — edited Jun 17 2014

Hello

I am setting up a new OUD 11.1.2.2 directory and using DIP to populate the users in the directory.  In OID (what I used before), I used the status_sync.jar integration to set the orclisenabled to disabled when a user was disabled in AD.  But, I do not see something similar in OUD / DIP for OUD.  Do you know if there is a plugin built into OUD to handle this in the mapping rules or some other way to handle this?  Any help you can give would be appreciated.

Thanks

Nick

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 Jul 15 2014
Added on Jun 12 2014
#identity-management, #oracle-unified-directory-oud-oracle-directory-server-enterprise-edition-sun-dsee
3 comments
1,527 views