Restrict Discoverer Data access

If you are new here, you may want to subscribe to the following feeds Business Intelligence ,InfoCaptor

Restrict Discoverer Data access

Written by kamlesh

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.

Posted in Discoverer |

2 Comments to “Restrict Discoverer Data access”

Ashwin Says:
December 4th, 2007 at 11:18 am
How do I find which user in discoverer has acces to particular business areas and work books.
We have around 30 business areas and 800 odd workbooks. We want to tighten the scurity so that a particular user can only access a specified BA. but for doing that we should
know the current status
Nilesh Says:
January 6th, 2008 at 12:38 pm
Hello Ashwin,
You can find the information using this dashboard/report

http://www.infocaptor.com/disco_help/workbook_sharing.htm?MenuState=31VVdVddVB

http://www.infocaptor.com/discoverer-dashboard.php

It provides lot of information. Let me know if you have any other questions

Thanks
Nilesh