RWB Security

Description
Categories: RWB
Polaris Reporting Workbench folder report security and sharing setup.
The report lists all responsibilities or users and the folders or reports they have access to

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
nvl2(rfrs.folder_id,'Folder','Report') security_type,
nvl(
decode(rr.report_type,'USER','Adhoc','SEEDED','Seeded Adhoc','DASH_BOARD','BI Publisher','VAR','PL/SQL Custom','FLEX','Dashboard','SEEDED_VAR','Seeded PL/SQL Custom',rr.report_type),
decode(rf.folder_type,'ADMIN','Data Objects','SEEDED','Seeded Reports','Oracle Reports')
) type,
nvl(rf.folder_name,rr.report_name) name,
xxen_util.user_name(rr.owner_person_id) report_owner,
frv.responsibility_name,
xxen_util.user_name(nullif(rfrs.user_id,rr.owner_person_id)) user_name,
decode(rfrs.share_level,1,'Report',2,'Output',3,'Report & Output') share_level,
xxen_util.user_name(rfrs.created_by) shared_by,
xxen_util.client_time(rfrs.creation_date) shared_date,
xxen_util.user_name(rfrs.last_updated_by) last_updated_by,
xxen_util.client_time(rfrs.last_update_date) last_update_date,
rfrs.folder_id,
rfrs.report_id,
rfrs.responsibility_id,
rfrs.user_id
from
rx_folder_report_security rfrs,
rx_folders rf,
rx_reports rr,
fnd_responsibility_vl frv
where
1=1 and
rfrs.folder_id=rf.folder_id(+) and
rfrs.report_id=rr.report_id(+) and
rfrs.responsibility_id=frv.responsibility_id(+) and
nvl(frv.responsibility_key,'x') not in ('XXRX_ADMINISTRATOR','XXRX_REPORTING_USER')
order by
nvl2(rfrs.folder_id,1,2),
type,
name,
frv.responsibility_name,
user_name