ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B299955A57005199E0530100007F7D61 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 Y US RWB Security 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 RWB 1=1