nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Delivered

BI Publisher

OTBI

Status: Delivered

Comments

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)

Navigate to Administration page
Open Properties under Runtime Configuration section
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)

Edit a report
Navigate to Report Properties, Formatting tab
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

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