PASSWORD PROTECTION FOR EXCEL (.XLS) OUTPUT SENT THROUGH ORACLE BI PUBLISHER

Abhijeet Wankhede-133167

Organization Name

Hilton Resorts Corporation

Description

The customer needs this functionality to password protect the Excel (.XLS) output because when they schedule BI Publisher reports that have output in Excel (.XLS) format and send the reports to clients by
contain critical business data.

Use Case and Business Need

The customer needs this functionality to password protect the Excel (.XLS) output because when they schedule BI Publisher reports that have output in Excel (.XLS) format and send the reports to clients by
contain critical business data.

Original Idea Number: 5d863e2d1f

Hamish Vickers

Many customers would find this useful - added security features for their data!

Carissa Karedes

Certain data contained in our instance of Oracle needs to be protected as part of the General Data Protection Regulation (GDPR). These reports should have password protection to ensure that this data is still protected once it is exported from Oracle. 

Ashish Shrivastava-Oracle

This features is implemented in 19.D. 

ENH 26197461 - ER: PASSWORD PROTECTION FOR EXCEL FILES SENT THROUGH ORACLE BI PUBLISHER

Lakshmi Sampath-Oracle

Great to know that this functionality is available now.

Hamish Vickers

Yes - looks as if it is all possible within the Report Properties, see the following Oracle doc;
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=11pv7i7sqn_4&_afrLoop=245136443132064#FIX

Robert Fighiroae-Oracle

You can use password protect as of Release 19C for PPTX, DOCX, XLSX, PDF (the password protection will apply to both online viewed reports and scheduled jobs):

TO APPLY PASSWORD PROTECTION

• To apply password protection at server level (i.e. for all reports that generates the output in PPTX, DOCX, XLSX, PDF)

1. Navigate to Administration page
2. Open Properties under Runtime Configuration section
3. Enter a desired password for the file formats

• To apply password protection at report level (i.e. for only specific report for PPTX, DOCX, XLSX, PDF outputs)

1. Edit a report
2. Navigate to Report Properties, Formatting tab
3. Enter a desired password for the file formats

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19C/19C-common-wn.htm#F9055

NOTE: Excel output in .XLS format generated from Excel templates do not support password protection.

Tessy

Hi Robert,

Do you have any suggestions to add extra security to an .xls template? Or do you know why we need to make te excel template as .xls?
Will oracle except .xlsx templates in the near future?

Kind regards,

Tessy

Tessy

Hi,

 

Can someone tell me if the security on .XLS will be enabled? 

If it will be possible in the future to use .XLSX templates instead of .XLS templates in BI Publisher?

 

Kind regards,

Tessy