Categories
PASSWORD PROTECTION FOR EXCEL (.XLS) OUTPUT SENT THROUGH ORACLE BI PUBLISHER
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
Comments
-
Many customers would find this useful - added security features for their data!
0 -
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.
0 -
This features is implemented in 19.D.
ENH 26197461 - ER: PASSWORD PROTECTION FOR EXCEL FILES SENT THROUGH ORACLE BI PUBLISHER
0 -
Great to know that this functionality is available now.
0 -
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#FIX0 -
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
NOTE: Excel output in .XLS format generated from Excel templates do not support password protection.
0 -
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
0 -
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
0
