Restrict Discoverer Data access

Categories: Other
Restrict Discoverer Data access by apps user_id, org_id, responsibility etc.. A simple solution is to create a simple sql folder in your EUL with the below query select fnd_global.resp_id, fnd_global.resp_name, fnd_global.user_id, fnd_global.user_name, fnd_global.employee_id, fnd_global.per_security_profile_id, fnd_global.org_id from dual; You can use this folder joined to any other folder to restrict data based on user_id, employee_id or org_id Alternatively you can incorporate the above query in your view to restrict data directly inside the view and use that view in the discoverer EUL folder.
« « Convert DFF (Descriptive Flex field) to Number                        Key to successful EPB implementation » »

Comments are closed.