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
The report lists all responsibilities or users and the folders or reports they have access to
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 |