Oracle Analytics Publisher Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Publisher Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Submitted
624
Views
8
Comments
Abhijeet Wankhede-133167
Abhijeet Wankhede-133167 Rank 1 - Community Starter
edited May 8, 2025 3:58PM in Oracle Analytics Publisher Idea Lab

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

Tagged:
6
Up
6 votes

Submitted · Last Updated

Comments

  • Hamish Vickers
    Hamish Vickers Rank 2 - Community Beginner

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

  • Carissa Karedes
    Carissa Karedes Rank 1 - Community Starter

    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
    Ashish Shrivastava-Oracle Rank 1 - Community Starter

    This features is implemented in 19.D. 

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

  • Lakshmi Sampath-Oracle
    Lakshmi Sampath-Oracle Rank 5 - Community Champion

    Great to know that this functionality is available now.

  • Hamish Vickers
    Hamish Vickers Rank 2 - Community Beginner

    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
    Robert Fighiroae-Oracle Rank 4 - Community Specialist

    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
    Tessy Rank 2 - Community Beginner

    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
    Tessy Rank 2 - Community Beginner

    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