LDAP Important Tables and SQL query in Oracle Cloud

LDAP Important Tables and SQL query in Oracle Cloud

 LDAP full means Lightweight Directory Access Protocol (LDAP). This is the Separate Directory Available in the Oracle cloud to handle Oracle Cloud application Users and their Privileges and roles. This is the Architecture of the Fusion application to keep the User Account information's details in this separate directory. Here below I will describe more about LDAP in oracle cloud.

 

 LDAP Important Tables

1.per_ldap_requests

2.per_ldap_users

 

 

 LDAP SQL query in Oracle Cloud

 

select plr.ldap_request_id, plr.request_status, plu.request_status user_request_status, plu.request_type,
ppn.last_name, ppn.first_name, plu.username requested_username, pu.username, plr.request_id, plr.active_flag,
      plr.error_code, plr.error_description
from per_ldap_requests plr, per_ldap_users plu, per_person_names_f ppn, per_users pu
where trunc(plr.last_update_date) >= trunc(sysdate-:dayOffset)
and plr.requesting_reference_id = ppn.person_id(+)
and plr.requesting_reference_id = pu.person_id(+)
and plr.ldap_request_id = plu.ldap_request_id
and ppn.name_type(+) = ‘GLOBAL’
and sysdate between ppn.effective_start_date(+) and ppn.effective_end_date(+)
and plr.request_status in (‘FAULTED’,’REJECTED’)
and plr.request_status = ‘COMPLETE’
order by plr.last_update_date desc;