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
Run RWB Security and other Oracle EBS reports with Blitz Report™ on our demo environment
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